How do you reference a control on another form in Access VBA?

How do you reference a control on another form in Access VBA?

To Access, a subform is just another control. To refer to it, use the name of the control. refers to the subfrmOrders subform on the frmCustomer form as a control. To refer to a control on a subform, use the Form property to tell Access that you are referring to the subform as a form, not as a control.

How do I link two forms in Access?

Create a datasheet or multiple-item form:

  1. In the Navigation Pane, select the table or query that contains the data you want on the datasheet form.
  2. Click Create > More Forms, then click Multiple Items or Datasheet, depending on which kind you want.
  3. Make any design changes you want.
  4. Save and close the form.

What is a form object in Access?

A form in Access is a database object that you can use to create a user interface for a database application. A “bound” form is one that is directly connected to a data source such as a table or query, and can be used to enter, edit, or display data from that data source.

What are the methods are there to Access a form?


  • GoToPage.
  • Move.
  • Recalc.
  • Refresh.
  • Repaint.
  • Requery.
  • SetFocus.
  • Undo.

What are form controls in Access?

Controls are the parts of a form or report that you use to enter, edit, or display data. Controls let you view and work with data in your database application. The most frequently used control is the text box, but other controls include command buttons, labels, check boxes, and subform/subreport controls.

How do I reference a report in Access VBA?

You can refer to an individual Report object in the Reports collection either by referring to the report by name, or by referring to its index within the collection. If the report name includes a space, the name must be surrounded by brackets ([ ]).

How do you link a form and a subform in Access?

How to Add a Subform to a Form in Access 2016

  1. Open the Form.
  2. Expand the Controls Toolbar.
  3. Select the Subform Option.
  4. Select the Data Source to use for the SubForm.
  5. Select the Fields.
  6. Choose the Linking Field.
  7. Name the Subform.
  8. The Subform in Design View.

How do you link fields in Access?

The Get External Data – Access Database import and link wizard opens. In the File name text box, type the name of the source database or click Browse to display the File Open dialog box. Click Link to the data source by creating a linked table, and then click OK.