Multi Tab Forms

[Cat]

I am building a Multi Tab form.

The first tab is for Employee information (name, address, etc.)
The second tab for Salary Information (Date hired, position) with a datasheet subform that would show annual salaries increases each year. There will be other tabs once I can get this to work.

I have built 3 seperate tables, 1 subject per table and linked them with a one to many relationship.

I built each form and copied them into the Multi Tab Form. Looks not bad for a beginner.

What I want to achieve is: When I look up employee #1, I want to see his info only in each tab; Employee #2 - only her info on all the tabs.

What I do see is Employee #2 on tab 1 with the Salary Info for Employee #1 on the 2nd tab. (Hope I am not confusing the help)

What simple thing have I missed doing? I only want to see the unique data of one employee at a time.

Are there any sample databases relating to Employee situtations or with multi tab forms that I can download (free) that anyone knows of?

Thanks in advance for the help.

Cat:

 

[[nateobot]]

Sorry don't know of any links to employee databases.

To help you with your problem tho:

I would make a query with all the data you want on the form (including all the tabs). Set the form Control Source to this query.

Then in each of the tabs you want "connected" put in the employeeID type of field you have. You can set the textbox's visible property to false so that noone can see it and it should in turn link all the tabs to what you search for on the initial tab.

-nate