Find record

[Bob Agoglia]

I am new to access. Years ago I used to program extensively in FoxPro so I have some fading knowledge. I am using Access 2010 if that makes any difference.

I have a database with 3 tables:
Contracts
Labor
Costs

My question is I created a tabbed "switchboar d" with 4 forms that each form is connected to a different table or query.

If I create a new record on one form and then go to another form I need the same contract number (contract_id) to appear on each form. Currently if I enter in a new contract and then go the the labor form to enter labor costs I am always at record #1 in that table.

Please if possible include where this code goes in the answer.

Thanks for all your help!
Bob

[RuralGuy]

Here's one possible solution: http://www.baldyweb.com/Bookmark.htm

[Bob Agoglia]

That would be a possible solution if I understood the code and where to put it. He uses Me.txtEmpId. Is Me a table? The property sheet for the navigation toolbar has several events such as On Got Focus, On Click. Where does the code go to make this work.

Again I am sorry for being so ignorant when it comes to MS Access.

Thanks,
Bob

[RuralGuy]

You are using the new NavigationToolB ar in Access 2010?

[Bob Agoglia]

Yes, I used the nav tool where you just drop forms & reports on the next tab.

Thanks.