Form Object
Multiple objects  Form Multiple objects |
A Form object refers to a particular Microsoft Access form.
Using the Form Object
A Form object is a member of the Forms collection, which is a collection of all currently open forms. Within the Forms collection, individual forms are indexed beginning with zero. You can refer to an individual Form object in the Forms collection either by referring to the form by name, or by referring to its index within the collection. If you want to refer to a specific form in the Forms collection, it's better to refer to the form by name because a form's collection index may change. If the form name includes a space, the name must be surrounded by brackets ([ ]).
| Syntax | Example |
|---|---|
| Forms!formname | Forms!OrderForm |
| Forms![form name] | Forms![Order Form] |
| Forms("formname") | Forms("OrderForm") |
| Forms(index) | Forms(0) |
Each Form object has a Controls collection, which contains all controls on the form. You can refer to a control on a form either by implicitly or explicitly referring to the Controls collection. Your code will be faster if you refer to the Controls collection implicitly. The following examples show two of the ways you might refer to a control named NewData on the form called OrderForm:
' Implicit reference.
Forms!OrderForm!NewData' Explicit reference.
Forms!OrderForm.Controls!NewDataThe next two examples show how you might refer to a control named NewData on a subform ctlSubForm contained in the form called OrderForm:
Forms!OrderForm.ctlSubForm.Form!Controls.NewDataForms!OrderForm.ctlSubForm!NewDataEach Form object has a Controls collection, which contains all controls on the form. You can refer to a control on a form either by implicitly or explicitly referring to the Controls collection. Your code will be faster if you refer to the Controls collection implicitly. The following examples show two of the ways you might refer to a control named NewData on the form called OrderForm:
' Implicit reference.
Forms!OrderForm!NewData' Explicit reference.
Forms!OrderForm.Controls!NewDataThe next two examples show how you might refer to a control named NewData on a subform ctlSubForm contained in the form called OrderForm:
Forms!OrderForm.ctlSubForm.Form!Controls.NewDataForms!OrderForm.ctlSubForm!NewData