basic question

[Wesley]

Once you have initially created a form and you have selected a table (s) to get data from how would you link another table (say, to a combo box)?

 

[R. Hicks]

If your form is to be bound to multiple table or queries ......

You need to use a query as the Record Source for the form instead of a table.

HTH
RDH

 

[Peter D]

Using the combo box wizard, you can select the table that is to supply the data for the control.

Open your form in design mode, click the combo box button on the toolbar, then draw the combo box on your form to invoke the wizard.

Hope this helps,

 

[Wesley]

is there a way of doing this without using the wizard?

 

[David R]

Go into the combobox properties

Under the Data tab, you should see an option for Row Source. You can set that to whatever you like, without using the wizard.

(Are your wizards broken, or are you just being fearless?)

You can use a tablename, queryname, or a raw SQL statement.

David R

 

[Wesley]

i dunno if they are broken, so much as they seem to want to work whenever they feel like it.

/shrug
/grins