Relationship Problems with 2 tables 1

[KevDBF]

HELP!

I am new to Access and have a problem.

I am trying to to go from one form and table to another form and table that share information on 1 person.

i.e. the first form contains their personal info (name,, address etc...) on one table and a button on that form allows you to go to their financial info which is on a different form and table. I have set it up this way to allow security access to only certain users.
I have have created a relationship between the Primary key of table one and the primary key of table 2 but when I go to the form connected to table 2 it always shows record number 1 NOT the record I was just on.

I hope this makes sense!

 

[lupins46]

When you add the 'openform' button to form1 using the wizard, it offers you the option of finding a match with the record you are on.
Add the button again and watch for the question.

 

[KevDBF]

Thank you - this drove me mad!