Matching record

A

Amour

Hi I am new to Access so please help.

I have a form (frmAttendance) and within this form I have a button. This
button opens another form (frmTravel). forms!frmAttendance!ssn =
forms!frmTravel!ssn and forms!frmAttencance!meet_num =
forms!frmTravel!meet_num. This all works great!

What the problem is: when I close the frmTravel it does not go back to the
current/matching record on frmAttendance.

Example:

frmAttendance ssn = 777-77-7777
frmAttendance meet_num = 45r45r
frmTravel ssn = 777-77-7777
frmTravel meet_num = 45r45r
This works great!

BUT when closing frmTravel
frmTravel ssn = 777-77-7777
frmTravel meet_num = 45r45r
Does not match
frmAttendance ssn = 888-88-8888
frmAttendance meet_num = 55555

I would like it to match:
frmAttendance ssn = 777-77-7777
frmAttendance meet_num = 45r45r

Maybe there is a setfocus or something that I need to do..

Thank You for any help....
 
Top