What is a control name in Access?
For a bound control, the default name is the name of the field in the underlying source of data. Controls on the same form, report, or data access page can’t have the same name, but controls on different forms, reports, or data access pages can have the same name.
How do I reference 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.
What is a control object in Access?
The Control object represents a control on a form, report, or section, within another control, or attached to another control.
How do you create a control form in Access?
To create a form from a table or query in your database, in the Navigation Pane, click the table or query that contains the data for your form, and on the Create tab, click Form. Access creates a form and displays it in Layout view.
What are the 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 you add a control to a form in Access?
To create a control that is bound to a field (meaning that the control will display and let you edit data from a table), open the Field List (Alt+F8) and drag the field from the list to the form, view, or report. Access adds a control that is appropriate for the type of data stored in the field.
How do you use activecontrol in VBA?
ActiveControl Property [Access 2003 VBA Language Reference] You can use the ActiveControl property together with the Screen object to identify or refer to the control that has the focus. Read-only Control object. expression Required. An expression that returns one of the objects in the Applies To list.
What is the activeform property setting?
This property setting contains a reference to the Form object that has the focus at run time. You can use the ActiveForm property to refer to an active form together with one of its properties or methods. The following example displays the Name property setting of the active form.
How do I make a form active?
You can make a form active by opening it, by choosing it or a control on it, or by using the SetFocus method in Visual Basic. The Activate event can occur only when a form is visible. The Activate event occurs before the GotFocus event; the Deactivate event occurs after the LostFocus event.
What is the use of activecontrol expression?
ActiveControl expression A variable that represents a Form object. This property setting contains a reference to the Control object that has the focus at run time. You can use the ActiveControl property to refer to the control that has the focus at run time together with one of its properties or methods.