Subforms with lists and combo boxes? (1 Viewer)

[Data Slave]

i'm trying to figure out a way to use a combo box in the list formated subform. I want you to be able to start typing the name and for it to pop up for you automatically. I also want a combo box for another property within the subform. I would like to still use the list format instead of the internal form format because it's easier to read.
Thanx for everything,
data slave.

 

[Pat Hartman]

If you are talking about using the datasheet view rather than the continuos forms view you will need to modify the table design.

Open the table in design view click on the column you want to modify, then choose the LookUp tab. Change the control type to combobox and specify a record source.

If the subform is based on a query rather than a table, you will probably need to switch to using the continuos form view and changing the control type to combobox there.