Switchboard (97)

Topic

New Reply

I have a database that has a switchboard. When I open a form from the switchboard and then close the form, I want it to go back to the switchboard. How do I make the switchboard reappear after I close a form?

Reply | Quote

Replies

For the form’s On Close event , use VBA (choose Code Builder) and type in the statement:

DoCmd.OpenForm “”

Alternatively, you can use a macro as the On Close event for your form (choose the Macro Builder): Select the “OpenForm” action and specify the Switchboard name as the “Form Name”.

Of course, the Switchboard is a form — its name should be listed on the Forms section of the Database Window.

Reply | Quote