FindFirst

[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

 

[Rick Brandt]

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

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