goto a record on a form based on criteria?

T

Timj

I want to find and goto a record on a form based on a set
of criteria.

Like if I do a dlookup to find record and get its ID,
goto that record.

I know its simple, but I can't seem to figure it out.

TIA,
Tim
 
M

Marshall Barton

Timj said:
I want to find and goto a record on a form based on a set
of criteria.

Like if I do a dlookup to find record and get its ID,
goto that record.

I know its simple, but I can't seem to figure it out.
Click to expand...


Here's the general idea:

With Me.RecordsetClone
.FindFirst "keyfield = " & keyvalue
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With
 

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

Goto Record Combo Box Problem 3
Need combo box to refresh when moving to new record 2017 1
goto 10
Open form to specific record from button on continuous form 4
Finding a Specific record problem 2
goto a specific record 4
You must use the dbSeeChanges option with Open Recordset whenaccessing a SQL Server table that has a 1
Cancel timer event if criteria not met 1

Top