Combo Box to find records from multiple tables

[cbella625]

So, I am getting very irritated at how to do this! Someone please help!

Basically, I have a main form that has fields from different tables. This is a research study, so each form enters data into different tables. Well, each record is a person's data. Instead of scrolling through each record, I need an option on the main form that allows me to search for a specific person and have their data populate into the form.

So far I am able to make a combo box that pulls up the record from one table. Well, HOW do i do it from ALL the tables!?? Do I have to make a query?

Anyone please help? I know this is "simple," but I just can't get it to work. Thanks!!!

[ssanfu]

Welcome to the forum

In general, yes, you would use a query. If the tables are related. It depends on your table relationships.

If the tables are related, you could make one big query and place the data on one form, you could have a tab control with several tabs to display different data on different tabs.

You could use a main form/sub-form arraignment - the main form to display the persons info and sub-forms to display related data from different tables. There would be one query per subform.

[cbella625]

Thank You! I figured it out

[rthakral]

How did you figure it out? Can you help me? I'm having the same trouble!!