Same Record ID from Form to Form

[bagoglia]

I am an old FoxPro programmer from back in the 90's but haven't done much with Access until now. I created a navigation form which I have 4 tabs that open 4 different forms. Each form is connected to a different table and one form is connected to a summary query. There are three tables and one query which all have a record_id field that joins them together.

If someone could please tell me the proper syntax and where the code should go so that when I click a tab the form I enter is on the same record_id as the form I left.

If it matters I am using Access 2010.

Thanks for your help!

 

[spoole]

If you Google search for "Ms Access Form based on another form" you should get what you need.

 

[missinglinq]

This would usually be handled with a Main Form holding the RecordID and other pertinent data, if any, and Subforms linked to this Main Form by the shared RecordID. As you add each Subform, one to a Tabbed Page, the Subform Wizard should automatically link these two Forms by this field.

Use the Main Form to select the RecordID you're interested in and the Forms on the Tabbed Pages will be kept in sync.

Linq ;0)>