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!!
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!!