Results 1 to 4 of 4
  1. #1
    stu_C is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    38

    Run macro on form load?

    Hi all
    Can anyone help me?



    if i have a macro called "TODATE" how do I auto run this when the form is opened by the user?

  2. #2
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,173
    Call it in the "On Open" event of the form.

    grNG

  3. #3
    stu_C is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    38
    Quote Originally Posted by NoellaG View Post
    Call it in the "On Open" event of the form.

    grNG
    i have tried this but struggling with the code

  4. #4
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,173
    Hi, if you have a macro, you don't need any code. Just click on the little down arrow on the left side of the event property. You'll see a list with available macro's. Just choose the macro you want to run when the event occurs.

    gr
    NG

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

Similar Threads

  1. Form Load Check
    By Kapelluschsa in forum Forms
    Replies: 3
    Last Post: 07-06-2011, 07:21 AM
  2. Form - Filter on load (if data exists)
    By dilbert in forum Forms
    Replies: 0
    Last Post: 08-13-2010, 11:39 AM
  3. Instant load of a form
    By carstenhdk in forum Forms
    Replies: 2
    Last Post: 05-06-2010, 12:27 AM
  4. Load Record from report in form
    By rdirosato in forum Reports
    Replies: 13
    Last Post: 03-08-2010, 10:35 PM
  5. On Load, form not visible
    By Bruce in forum Forms
    Replies: 15
    Last Post: 02-24-2010, 04:06 PM

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