Results 1 to 3 of 3

Thread: My form doesen't start fully before my code starts?

  1. #1
    Pirre001
    Guest

    Question My form doesen't start fully before my code starts?

    My form doesen't start fully before my code starts in VBA?
    How do I complete the code so my form can start fully before the code runs.
    VB Code:
    1. DoCmd.OpenForm "Info"
    2. Screen.MousePointer = 11
    3. 'Here i run my code
    4. Screen.MousePointer = 1
    5. DoCmd.Close acForm, "Info"

  2. #2
    Addicted Member goudabuddha's Avatar
    Join Date
    Jun 2001
    Location
    Somewhere cheesy
    Posts
    203
    The loading order for a form's events are: Load -> Activate -> Paint

    Put your code in the activate event. Then it will run after the form is loaded. If you want the form to display first put it in the Paint event but be careful...that event fires every time the form is moved/resized

  3. #3
    Randalf the Red honeybee's Avatar
    Join Date
    Jun 2000
    Location
    off others' brains
    Posts
    4,345

    Well ...

    Or include Form.Show and Form.Refresh statements before executing your code. That will make sure that the form is visible on the screen before your code executes.

    .
    I am not a complete idiot. Some parts are still missing.
    Check out the rtf-help tutorial
    General VB Faq Thread
    Change is the only constant thing. I have not changed my signature in a long while and now it has started to stink!
    Get more power for your floppy disks. ; View honeybee's Elite Club:
    Use meaningfull thread titles. And add "[Resolved]" in the thread title when you have got a satisfactory response.
    And if that response was mine, please think about giving me a rep. I like to collect them!

Posting Permissions

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



Click Here to Expand Forum to Full Width