FindFirst

  • Thread starter Thread starter smk23
  • Start date Start date
S

smk23

I am trying to use

Me.RecordsetClone.FindFirst "ContactID = " & lngContactID
Me.Bookmark=Me.RecordsetClone.Bookmark

methodology to move to a record with no response. The underlying recordset
is a pass through query. Is that the problem? Is there another way to do this?

Sam
 
smk23 said:
I am trying to use

Me.RecordsetClone.FindFirst "ContactID = " & lngContactID
Me.Bookmark=Me.RecordsetClone.Bookmark

methodology to move to a record with no response. The underlying
recordset
is a pass through query. Is that the problem? Is there another way to
do this?

Sam
Click to expand...

My first guess is that the FindFirst failed to find any matching record.
You should test for NoMatch

With Me.RecordsetClone
.FindFirst "ContactID = " & lngContactID
If .NoMatch Then
MsgBox "Record Not Found"
Else
Me.Bookmark = .Bookmark
End With
 
Back
Top