AUTO FILL FROM A COMBO BOX

[crowee]

I am having a metal block here. I have a Company table and then the Company contact table. Many contacts for each Company. I have my form set up as Company is the main form then a joined table that opens to all the contacts for that company. I am trying to set it up that from the Company Form when I pick a company from the drop down list it fills in all the other info on the form for that company. ie. address, city, state, phone etc. Please help with this. Sorry this is such a winded question.

Thanks

 

[MazeWorX]

You could base the form on a query and make the details a subform of your main form

it all depends on what you want this form to eventually do?

 

[crowee]

I want it to be used for a mailing list and to make labels