Results 1 to 4 of 4
  1. #1
    George is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2012
    Posts
    295

    Method to close a form

    Good Day All.

    I have a form "Form1" open and it has a button which when press can close the form easy with a macro using the close method; however when used with a procedure I cannot find a close method to achieve the objective.

    Can anyone guide me to the solution?


    Thanks in advance

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Try
    Code:
    Docmd.Close acForm, Me.Name
    Or

    Code:
    Docmd.Close acForm, "Form1"


    In the ribbon, there is an option to convert a macro to VBA code.......

  3. #3
    George is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2012
    Posts
    295
    Ssanfu number 2 worked. Thanks

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Happy to help......

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

Similar Threads

  1. Replies: 7
    Last Post: 05-12-2016, 06:02 PM
  2. Replies: 15
    Last Post: 01-23-2016, 03:16 PM
  3. Replies: 4
    Last Post: 01-31-2014, 11:47 AM
  4. Replies: 2
    Last Post: 06-20-2011, 03:10 PM
  5. Open Form with instance method & wait to close?
    By GeorgeBakoyannis in forum Forms
    Replies: 1
    Last Post: 10-09-2010, 11:00 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