Code help Me.RecordsetClone.FindFirst

vjb

Registered User.
Local time
Today, 08:38
Joined
Jul 31, 2002
Messages
14
I have the following code in the After Update event of a combo box.

Sub Como78_AfterUpdate()
Me!RecordsetClone.FindFirst "[Membership #] = '" & Me![Combo78] & " ' "
Me!Bookmark = Me.RecordsetClone.Bookmark
Me![renewal date].setfocus
End Sub

It worked fine for years but now sometimes gives the following error:

"You can't go to the specified record at this time. You may be at the end of the record set."
Debug End Cancel

(or something close to that anyway)

There are over 26,000 records in the table. The record is actually in the table. I can exit Access, go back in and try it again and it will work. This might happen 8 to 10 times a day for the user.

Is there something I can add to the code to help?

Thanks again!!
 
Have you compiled and saved all modules, compacted the db lately?
 
Thanks to you both for the suggestions. I'll check them out!
 

Users who are viewing this thread

Back
Top Bottom