two forms -two tables (Access ’97)

Topic

New Reply

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.

Reply | Quote

Replies

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

Forms("Form2").Visible = True
Me.Visible = False

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

Forms("Form1").Visible = True
Me.Visible = False

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.

Reply | Quote

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.

Reply | Quote

Or Ctrl PgUp/PgDown for the tabs.

Reply | Quote