Hi,
I have successfully created several Combo Boxes by creating the lists in a table.  However, I have not been able to create the drop down lists from a table within my Subforms.  In this situation I have had to use the Lookup Wizard to get it to work.  I have a feeling it has something to do with the type of relationships I am defining, as I keep getting an error pop-up in the Subform Wizard when I try to create the Subform from two different tables (one for the Subform, the other for the drop-down list like for a Combo Box).  However, I am concerned that there will be limitations on querying the data from the Lookup Wizard as opposed to the Table-Combo Box method.  Is the Lookup Wizard for the data type in this situation a bad way to do this, or will I regret it later?  Please advise.

---

Reply from Alex Hedley:

Hi Michael
Try creating the Query you wish to use to fill your combo, when that is working you can then set that to be the source of your combo.