I'm sure this is something simple, but i can't seem to find it. I think i'm probably using the wrong search terms. So if this was answered elsewhere, i apologize.
Here are the steps i'm trying to take...
- I open a recordset in vba based on some conditions. Note: there will always be multiple records returned in this recordset.
- I then find one specific record in that recordset.
- I want to then open up a form with the multiple-record recordset behind it (so user can navigate back and forth through the found records).
- Then i want the form to jump to the specific record i previously found in the code - This is the part i need help with
Note: FindFirst will always be successful (no need to check for matches).
.FindFirst "hearingdate = " & HearingDate
DoCmd.OpenForm "frmHearing", acNormal
Set Forms!frmHearing.Recordset = myRecordset
-----This is the question...now that the form is open with the desired recordset-------
-----I want to jump to the specific record that was found using FindFirst----
Set myRecordset = Nothing
Set myDB = Nothing
I know this must be super simple. But i just can't seem to locate the solution for whatever reason.