I have a form in Access 2000 that gets "stuck" on the record being viewed, such that the user can't use nav buttons to go to other records (the form stays put on the current record), and the user can't do a Ctrl-F search for other records (none are found). It's as if the form's recordset suddenly becomes ONLY the record being viewed. To clear the problem, the user has to close and re-open the form.
The problem occurs explicitly after a certain checkbox control is checked or unchecked. The AfterUpdate event on this control must have something to do with the problem... However, nearly identical AfterUpdate events on other controls do not cause this effect. As a matter of fact, this checkbox control calls the same event function as some other controls -- and yet only this checkbox is followed by the "sticky" situation.
What causes a form to get "stuck" on the current record, and how can I fix it?
P.S. For more info and the event code(s), please see http://www.experts-exchange.com/Databases/Q_21481308.html
. A solution to either question gets the points from both.