Replies

Where is the master table of companies? Usually, in a normalized db, this situation would have two tables with a 1:M relationship (i.e. TABLE A (companies) contains one company record per company; TABLE B (actions) would contain all action records for the companies in TABLE A). Selecting a company from listboxA would then populate listboxB with all records from TABLE B for that company. Why do you need to store this information in another table for a forms recordsource?

One answer would be to export all of the tables to be combined to a separate mdb. Then link those tables to the main db. Loop thru the tables collection and, if the Connect property is >0 then run an append query to move the data into the combinedTable. Delete that linked table and continue with the next until the data is all combined.

HTH
Jim

please post the code access created so we can see what is happening

there is no such thing as a dropdown in a listbox. You are describing a combobox