Unanswered: Problems with Form Events re: Performance
A question regarding Form Events and their effect on performance.
I have an Access 2000 app that has a search form as well as a main form with a Tab view. Each Tab has one on more subforms on it. Just about all the forms and subforms have code for their respective Current events.
The user chooses a record from the search form then the main form is loaded with the data for the chosen record.
When running in debug mode, I noticed that the following happens:
- on startup, all Current Events for all forms run TWICE
- on select of record and main form load, all Current Events for all forms run THREE TIMES
- on tab change, all Current Events for all forms run TWICE
I would really like to eliminate these if they are redundant calls. Any help would be great.