no current record on requery

F

Fredrated

I have a form which allows a user administrating classroom courses to check
off who attended, from the sign-in sheets. To make things easier, there is a
button at the bottom to [Check off all students] and flag all as attended.
This button runs a sql query which does the trick.
After running the query, I issue the command (in the form code) "Me.Requery"
This usually works, but about 20% of the time I get a "No current record"
error. This is even when there are in fact student enrollment records.

Any idea what is causing this error, and what to do about it?

Thanks
Fred
 
Top