Code running/flickering (Access 2003)

[Stuart]

I have two monitors, and can see both the code window and the form
simultaneously. In one particular database, when I modify a form's code and
then save the form, the code window goes wild. It appears to be running some
code many many times. After a half minute or so, it stops. Can anyone
explain this behavior and how I can stop it?

Things I have tried to no effect:
1. Compact/repair
2. Create a new database and import all the objects from the old database.
3. Search for and eliminate onTimer events (there were none)

 

[Jeanette Cunningham]

Stuart,
one thing to check is the Current event for that form.
The way you write code that covers things that need to be set up or checked
when a form opens and loads, can trigger a flurry of action for the Current
event. For example, setting values of any controls.

Jeanette Cunningham