Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Switchboard (97)

    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?

  2. #2
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Switchboard (97)

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

    DoCmd.OpenForm "<Switchboard Name>"

    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.

Posting Permissions

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