mud2
01-09-2007, 09:55 PM
in the design of Table1 I included a table2 which is used for the source of a combobox for one of the fields in table1.
If I use the WIZARD to design a form based on table1 the drop down list appears...BUT
If I want to design the form by assigning its controlsources and record in its Form.activate routine with VBA, such as ControlSource - "Table1"...I can't get the drop down list. I have a text box in this form, and its control is the field in table1 with the drop down list, but I can't get the drop down!
??
If I use the WIZARD to design a form based on table1 the drop down list appears...BUT
If I want to design the form by assigning its controlsources and record in its Form.activate routine with VBA, such as ControlSource - "Table1"...I can't get the drop down list. I have a text box in this form, and its control is the field in table1 with the drop down list, but I can't get the drop down!
??