i have made a data entry form with two combo boxes.
The first one called [company ID] from the table [company] with the
row source:
Expand|Select|Wrap|Line Numbers
- SELECT [company].[company ID], [company].[company name] FROM company;
the next combo box is called [subs ID] from the table [subsidiary]
( incl. subs ID, company ID, ...),
which populates the combo box with the correct list of subsidiaries of the company chosen in the first combo box.
row source:
Expand|Select|Wrap|Line Numbers
- SELECT subsidiary.[subs ID], company.[company ID], subsidiary.[subs name] LEFT JOIN subsidiary ON company.[company ID]=subsidiary.[subs ID] WHERE ((([company].[company ID])=[Forms]![xxx]![company ID]))
how can i refresh or requery the list of the second combo box???