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....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not current record 0
You can't go to the specified record 4
adding a record 0
Popluating a form 3
recordsource updatable 3
Popluating a form from another table 1
Checking for new records 0
Adding a record 3

Top