Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004

    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.

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    It's just logic. Can't really help you without seeing the code.

    A quick fix could be setting a flag you evaluate to decide whether or not to execute the code.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Dec 2004


    All, here is pretty good answer that I got from another site:

    Look in your code for those places where you change records! When a record is changed the Current Event of the form is always triggered.

    Start by checking all the Current Events. If code in any Current Event changes record, it can easily become recursive.

    Depending on your subform structure, you may easily be getting cascading effects of the above . . . . .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts