I have a form that relates to data in another form. I want to go to the related record in the other form.
I already have the code working in another form, and it goes to the record selected as expected:
DoCmd.OpenForm "frmPIO", acNormal, "IOID=" & Me!IOID
DoCmd.Close acForm, "frmIO"
I have created a click button on a different form and added similar code for the same purpose of opening another form with the record in view. BUT, when the form opens, it seems to ignore the code telling it which record to display and ALWAYS GOES TO THE FIRST RECORD.
Form with button on: frmIO
Form to open at specific record: FrmPIO
Common identifier = "IOID" - is a number field, and is on both forms.
Your help arreciated!