Viewing the Same Record on Different Forms

[JasonTruman]

Hi All

When I am viewing a record on one form, I then want to be able to view the same record on a different form (for which there is another table with the same record ID just with different data) and therefore want to sync the relevant record values.

I already have my 2 forms setup with a command button to open the second form, so when I click on the button I want it to show the same record that is from the other table on this form

Any ideas

Much appreciated

Jace

 

[JasonTruman]

Sorted it thanks guys

Via the command button wizard there is an option to sync the records based on the necessary field names

Jace