|New! Download a running example of the Docmd.OpenForm Method|
WhereCondition - A string expression containing an SQL WHERE clause without the word WHERE. Such as, "Order_ID=" & Me.Order_ID
DataMode - The data entry mode for the form. This only applies to forms in Form view (default) or Datasheet view. The DataMode argument has the following options:
acFormAdd - The user can add new records but can not edit existing records.
acFormEdit - The user can edit existing records and add new records.
acFormPropertySettings - (default - uses form's property settings)
acFormReadOnly - The user can only view records.
WindowMode - The window mode in which the form opens. Window Mode can have the following values:
acDialog - The form's Modal and PopUp properties are set to Yes.
acHidden - The form is hidden.
acIcon - The form opens minimized in the Windows taskbar.
acWindowNormal - (default) Used the forms mode settings.
OpenArgs - A string expression used to set the form's OpenArgs property. The OpenArgs string can then be used by code in a form module, such as the On Open event procedure to perform actions based on the open arguments value.
More Open Form examples:
Copyright 2000-2013 Blue Claw Database Design, LLC