Results 1 to 5 of 5
  1. #1
    djclinton15 is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Nov 2015
    Posts
    123

    How to open second Form using a Macro

    Hi, I'm trying to have a second Form be opened when dbs is open. I went through a Macro; chose 'Open Form,' then chose the Form I wanted opened (second Form) & what view I wanted the Form to open as (datasheet). Close/open the dbs & the second Form didn't open. I once had 2-Forms open when dbs started/opened, but it wa a great while back & I forget had I did it in a Macro




    Any advise/suggestions will be greatly appreciated! Thanks in advanced.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Macro:
    openform form1
    openform form2

  3. #3
    djclinton15 is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Nov 2015
    Posts
    123
    Thanks for responding to my thread. Your suggestion is only working when I click on the Macro, however neither Forms opens when I first open up the dbs. This is frustration me; you can have more then one form open when you open the dbs? I did the 2-Forms in one Macro or should I do it in two separate Macros?

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I never use macros.

    But if you want two forms to open when the dB opens, I would try having a macro named "Autoexec". The steps for opening both forms should be in this macro.

    I just tried it and opened 3 forms.....

  5. #5
    djclinton15 is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Nov 2015
    Posts
    123
    Yes, "Autoexec" was what I named the Macro in the past. Thanks!

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

Similar Threads

  1. Replies: 3
    Last Post: 06-04-2015, 08:17 AM
  2. Replies: 7
    Last Post: 09-16-2014, 02:35 PM
  3. Replies: 1
    Last Post: 07-02-2014, 11:22 AM
  4. Macro to open report based on value in a form
    By iProRyan in forum Macros
    Replies: 2
    Last Post: 02-24-2014, 03:02 AM
  5. Replies: 2
    Last Post: 10-09-2013, 05:45 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