Same record Different forms

[newbieone]

I have created a database to show employee's personal information, what training they have had and any certifications they may have. I have three tables Contacts, training and Accreditation. I have three forms again contacts, Training and Accreditation. I need to show a record on the contacts form and have it be linked to the training and accreditation forms/tables. I have set up the relationships with a the primary key on the contacts table and the foreign keys on training and accreditation.
how do I select a record by a drop down box on the contacts table and have linked to the same record on the training and accreditation tables while allowing updates to the selected record?

 

[JerryKlmns]

Like a form with 2 subforms?
On the contacts form (in design view), drop those other forms and follow the wizard for Link Master Fields + Link Child Fields.

 

[newbieone]

As it stands, right this minute there are three separate forms. I did this so that eventually I can control access to the different forms for security reasons. Is there any way to keep the forms separate and still have them linked?

 

[JerryKlmns]

Ok, then use the IsLoaded property of an AccessObject (=AllForms for your case) and if true reference the control that keeps the employee's ID and use it for the other form (Training or Accreditation) activation event

 

[newbieone]

Thank you for the help, I got it to work a slightly different way.