goto a record on a form based on criteria?

  • Thread starter Thread starter Timj
  • Start date Start date
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
 
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
 
Back
Top