Results 1 to 3 of 3
  1. #1
    Twitchie is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    20

    Limiting Form's OnLoad MsgBox to One Instance

    I have a form that AutoExec (the only macro in my db) launches when the db is opened. In the form's OnLoad event, I have a MsgBox that pops up with basic instructions and a vbOKOnly button. Is there a way to limit that MsgBox to only appear once per session? That way if the user navigates back to that menu screen during the same session, the MsgBox doesn't reappear? It's not critical, just something I thought may be nice. Many thanks in advance!

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    The On Load event is triggered as the request to Open the form is processed. Place your msg box in a form that will only open once.

    Another approach would be to include the msgbox directly in your AutoExec

  3. #3
    Twitchie is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    20
    Quote Originally Posted by ItsMe View Post
    The On Load event is triggered as the request to Open the form is processed. Place your msg box in a form that will only open once.

    Another approach would be to include the msgbox directly in your AutoExec
    Awesome! Thanks much! I created a form that launches the MsgBox onLoad and then onPaint closes it and launches the main menu, which now takes place automatically after the user clicks the OK button on the MsgBox. Thanks!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 10-11-2013, 07:29 AM
  2. Create new form instance at the module level
    By DevSteve in forum Modules
    Replies: 1
    Last Post: 09-11-2012, 11:47 AM
  3. Record Check on Form OnLoad
    By tramp82 in forum Forms
    Replies: 10
    Last Post: 10-19-2011, 07:19 PM
  4. Open Form with instance method & wait to close?
    By GeorgeBakoyannis in forum Forms
    Replies: 1
    Last Post: 10-09-2010, 11:00 AM
  5. Multiple Instance Form
    By steve.roic@bellsouth.net in forum Forms
    Replies: 0
    Last Post: 05-19-2010, 11:18 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums