Results 1 to 4 of 4

Thread: Show (2) Form Tabs Open when Access is Opened

  1. #1
    Board Regular
    Join Date
    May 2007
    Posts
    591
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Show (2) Form Tabs Open when Access is Opened

    I have the access settings to show one form through options when Access is opened, but is there a way to show (2) form tabs when access is opened?

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    51,060
    Post Thanks / Like
    Mentioned
    57 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Show (2) Form Tabs Open when Access is Opened

    You could use an "AutoExec" Macro (which runs when the database is opened), and have it open two Forms (though one will be displayed, and the other will be in the background).

    Alternatively, you could create a new Form, and have your other two Forms be unrelated Subforms on your new Form.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular
    Join Date
    May 2007
    Posts
    591
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Show (2) Form Tabs Open when Access is Opened

    I figured, it out, when I open, it opens to the 2nd tab, how can write it in to open to the 1st tab?
    Last edited by squeakums; Sep 23rd, 2019 at 12:55 PM.

  4. #4
    Board Regular
    Join Date
    Jul 2010
    Posts
    464
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Show (2) Form Tabs Open when Access is Opened

    On the macro add a third open form Action and set it to open the first form again - as it is already open it will just have the focus set back to it.

    Edit: Use the selectobject action - and select form 1. either one will work but that Is probably a better action to use.
    Last edited by stumac; Sep 23rd, 2019 at 01:00 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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