Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    two forms -two tables (Access '97)

    Is it possible to setup Access with a button or two - to toggle between two different forms, having only one form showing at a time? Thanks in advance.

  2. #2
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: two forms -two tables (Access '97)

    Assuming both forms are open you can add acommand button on Form1 With this code in the click event of the button:

    <pre>Forms("Form2").Visible = True
    Me.Visible = False</pre>


    And on Form2 have a command button with this code in the click event:

    <pre>Forms("Form1").Visible = True
    Me.Visible = False</pre>


    You will need to make sure that both forms get opened at the same time and if one of the forms gets closed it either unhides the second form or closes it.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  3. #3
    Star Lounger
    Join Date
    Sep 2001
    Location
    Pleasanton, California, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Or use tab control

    Or you could put a two-page tab control on one form and put a table on each tab. then it is as simple as clicking the tab to change tables.

  4. #4
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Or use tab control

    Or Ctrl PgUp/PgDown for the tabs.

Posting Permissions

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