Trouble with combo boxes!

[stuartm]

Hi everyone,

This would seem like the easiest thing in the world to do, but I can't find out how. Am I over-complicating things?

I have lists of tables of contacts (a new table for each company). On my "Menu" form, which loads up when the database opens I want to be able to have a combo box that lists the companies (I have the company names in a separate table), so that the user simply picks the company name from the drop down list, then presses a command button and is taken to the first record of that company's table (in form view).

I've spent ages trying to work out how to do this but I'm failing miserably. All help appreciated! Many thanks. Stuart.

 

[boblarson]

Tables are not ordered the way you are thinking. What you want to do, is to create a form with a subform and then have the combobox select the company and then the subform can be on the main form as datasheet, so it looks like the table, and can be updated like the table, but it has a recordset behind it which is tied to the company ID on the combobox.

 

[Rich]

You have a design problem, you should not have separate tables for each company, search here for posts on normalisation