Results 1 to 4 of 4
  1. #1
    FranCorona is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    May 2013
    Location
    California
    Posts
    74

    Close form after clicking command button to open report


    Hello, I have a form that has a command button that opens a specific report based on criteria from a combo box, but the form stays open on top of the report, I have tried the docmd.close but it closes the report and not the form. I dont need to save anything, I just need it to close the form when I click the command button to open the report. I know it's probably something so simple but I am missing it....

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Look in help at DoCmd.Close; there are arguments available for it.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    FranCorona is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    May 2013
    Location
    California
    Posts
    74
    Thank you, I knew it was something simple.... Have a great day! Fran

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    No problem Fran!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 9
    Last Post: 09-17-2013, 11:08 PM
  2. Replies: 14
    Last Post: 02-19-2013, 03:16 PM
  3. Replies: 2
    Last Post: 05-11-2012, 11:52 AM
  4. Replies: 11
    Last Post: 01-26-2012, 01:22 PM
  5. Command button to open Report
    By swagger18 in forum Programming
    Replies: 0
    Last Post: 11-17-2011, 02:56 AM

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