troubleshooting Question

Access VBA - Open a form, jump to the record found in a recordset

Avatar of Matt Chornomaz
Matt Chornomaz asked on
VBA
3 Comments1 Solution55 ViewsLast Modified:
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).

With myRecordset
    .FindFirst "hearingdate = " & HearingDate
End With

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

Forms!frmHearing.Requery

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.

Thanks!
ASKER CERTIFIED SOLUTION
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros