FindFirst

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
 
R

Rick Brandt

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
 

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

RecordSet.FindFirst 2
recordsetclone does not update form display 2
RecordSet Bookmark Property 3
subform reference question 3
How to select one item in a listbox to requery subform 3
function assistance 5
cbo AfterUpdate question 5
Why does this code work? 4

Top