Results 1 to 3 of 3
  1. #1
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727

    minimize switchboard when opening report


    All, using 2010. I am using a form with command buttons to open reports. When I open the report I close the form but when I close the report I have to reopen the form manually. I don't normally put command close buttons on reports. Is there anyway without using a command close button on the form to reopen the form?

  2. #2
    nick404's Avatar
    nick404 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2015
    Location
    Wisconsin
    Posts
    352
    There is, you can put
    Code:
    DoCmd.OpenForm "YourFormName"
    on the On Close event of the report(s).

    However, if you open reports from this main form, then close the form when you run a report, and then want to re-open the form why do you close the form to begin with?

  3. #3
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727
    thanks. I knew it was something simple.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Close the Switchboard when opening a form
    By Silvera in forum Forms
    Replies: 3
    Last Post: 08-11-2015, 03:02 PM
  2. Replies: 1
    Last Post: 02-21-2015, 11:35 PM
  3. Replies: 4
    Last Post: 11-06-2012, 08:36 AM
  4. Opening a PDF from a Switchboard
    By Huddle in forum Access
    Replies: 2
    Last Post: 05-17-2012, 08:08 AM
  5. maximize switchboard upon opening
    By zrawe16 in forum Access
    Replies: 4
    Last Post: 05-27-2011, 12:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums