| |
OpenForm Action
You can use the OpenForm action to
open a form in Form view, form Design view, Print Preview, or Datasheet
view. You can select data entry and window modes for the form and
restrict the records that the form displays. This action is similar to
clicking the Open button or Design
button after clicking Forms under
Objects, and then selecting a form in the Database window.
The OpenForm action has the
following arguments.
| Action argument |
Description |
| Form Name |
The name of the form to open.
The Form Name box in the Action
Arguments section of the Macro window shows all forms in the
current database. This is a required argument.
If you run a macro containing the
OpenForm action in a library database, Microsoft Access looks
for the form with this name first in the library database, then
in the current database. |
| View |
The view in which the form will
open. Click Form, Design,
Print Preview, Datasheet,
PivotTable, or PivotChart in
the View box. The default is
Form.
Note The View argument
setting overrides the settings of the form's
DefaultView and ViewsAllowed properties.
For example, if a form's ViewsAllowed property
is set to Datasheet, you can still use the
OpenForm action to open the form in Form view. |
| Filter Name |
A filter that restricts or sorts
the form's records. You can enter the name of either an existing
query or a filter that was saved as a query. However, the query
must include all the fields in the form you are opening or have
its OutputAllFields property set to
Yes. |
| Where Condition |
A valid SQL
WHERE
clause (without the word WHERE) or
expression
that Access uses to select records from the form's underlying table or query. If you
select a filter with the Filter Name argument, Access applies
this WHERE clause to the results of the filter.
To open a form and restrict its
records to those specified by the value of a control on another
form, use the following expression:
[fieldname]
= Forms![formname]![controlname
on other form]
The fieldname argument is
the name of a field in the underlying table or query of the form
you want to open. The controlname on other form argument
is the name of the control on the other form that contains the
value you want records in the first form to match.
Note The maximum length
of the Where Condition argument is 255 characters. If you need
to enter a more complex SQL WHERE clause longer than this, use
the OpenForm method of the DoCmd
object in Microsoft Visual Basic instead. You can enter SQL
WHERE clause statements of up to 32,768 characters in Visual
Basic. |
| Data Mode |
The data entry mode for the
form. This applies only to forms opened in Form view or
Datasheet view. Click Add (the user can add
new records but can't edit existing records), Edit
(the user can edit existing records and add new records), or
Read Only (the user can only view records).
The default is Edit.
Notes
- The Data Mode argument
setting overrides the settings of the form's
AllowEdits, AllowDeletions,
AllowAdditions, and
DataEntry properties. For example, if a form's
AllowEdits property is set to
No, you can still use the OpenForm action
to open the form in Edit mode.
- If you leave this argument
blank, Access opens the form in the data entry mode set by
the form's AllowEdits,
AllowDeletions, AllowAdditions, and
DataEntry properties.
|
| Window Mode |
The window mode in which the
form opens. Click Normal so the form is in the
mode set by its properties, Hidden (the form
is hidden), Icon (the form opens minimized as
a small title bar at the bottom of the screen), or
Dialog (the form's
Modal
and
PopUp properties are set to Yes). The
default is Normal. |
|