I need a combobox to get its list items from 2 different tables (with identical structures). I can't figure out how to create a query (for the rowsource) to do this.
Any ideas?
Printable View
I need a combobox to get its list items from 2 different tables (with identical structures). I can't figure out how to create a query (for the rowsource) to do this.
Any ideas?
Use 'UNION' function in your SQL query
to select from both tables.
Another option is to try and get your data into Access and build your query in Access.
Verify that the correct data is returned and then go back to the design of the query and go to the View SQL window and whala..you got your SQL code.
Hope it helps!