Below are the syntax and command options for the Close method:
(method syntax continued on next line)
ObjectType Optional AcObjectType.
AcObjectType can be one of these AcObjectType constants:
Are you just starting out on your quest for a database? Need some advice or someone to bounce ideas off of? We are here and will be happy to chat with you on the phone and discuss options to your situation. Visit our contact page and give us a call.
Did you know that most template databases often do not do exactly what you need done? We can create a custom template that fits your needs exactly for a small to medium Access database at a reduced cost. See our contact page and call Joseph Dean for more info.
Note If closing a module in the Visual Basic Editor (VBE), you must use acModule
in the objecttype argument. ObjectName Optional Variant. A string expression that's the valid name of
an object of the type selected by the objecttype argument.
Save Optional AcCloseSave.
AcCloseSave can be one of these AcCloseSave constants.
acSavePrompt - default This value is ignored if you are
closing a Visual Basic module. The module will be closed, but changes to the
module will not be saved.
acSaveYes - If you leave this argument blank, the default
constant (acSavePrompt) is assumed.
If you leave the objecttype and objectname arguments blank
(the default constant, acDefault, is assumed for objecttype), Microsoft Access
closes the active window. If you specify the save argument and leave the
objecttype and objectname arguments blank, you must include the objecttype and
objectname arguments' commas.
Note If a form has a control bound to a field that has its Required property set
to 'Yes,' and the form is closed using the Close method without entering any
data for that field, an error message is not displayed. Any changes made to the
record will be aborted. When the form is closed using the Windows Close button,
the Close action in a macro, or selecting Close from the File menu, Microsoft
Access displays an alert. The following code will display an error message when
attempting to close a form with a Null field, using the Close method.
The following sample code uses the Docmd.Close method to close the form Order Review,
saving any changes to the form without prompting:
DoCmd.Close acForm, "F_Orders", acSaveYes
NotInList Event in Microsoft Access