Previous Thread

7/6/2006 8:51:02 PM    Combo boxes on query datasheet view
In the Northwind application some of the queries such as Alphabetical product 
 
list has combo boxes appear for some of the fields in datasheet view, and 
 
they also show up if you place the query in a mainform as a subform. How do I 
 
create a datsheet like this.? Can this be done in Access 2000?



7/6/2006 9:53:57 PM    Re: Combo boxes on query datasheet view
JoeA2006, 
 
This sounds like the table the query is based on has a lookup for the fields that have these combo boxes in them. 
 
In the Design view of the table, in the Data Type column for the field you want this combo box for, select "Lookup Wizard...". 
 
I hope this helps, 
 
Conan Kelly 
 
"JoeA2006" <JoeA2006@discussions.microsoft.com> wrote in message news:59DD1DBD-3D22-4720-A6F4-E161DDBA4E2D@microsoft.com...