Tab Control

Judd123

New member
Local time
Today, 08:04
Joined
Dec 8, 2008
Messages
8
Hi,Im trying to make a database using the Tab Control. Each tab has data from a different table and they are all linked by Cadet_ID. After I make a combo box which "find a record on my form based on the value I selected in my combo box" (Name).It works when there is the data from one table but as soon as i add fields from other tables nothing worksIf you know why this is, it would be of great helpThanks
 
A form can only have one table or query as its data source. The tab control doesn't actually create more forms on your main form. I think you might want to try sub forms on each tab for what you're trying to do.
 
Probably best to create a query that link all your table by the Cadet_ID and then carefully check your query JOIN to use LEFT JOIN on tables that do not always have a related record to the main table.

Set the control source of the form to that query.
 
Thank you both for your sugestions, i will try them both and see if i can get any further in my projectMuch appreciatedChris
 

Users who are viewing this thread

Back
Top Bottom