Screen.ActiveForm property (Access)

Use the ActiveForm property together with the Screen object to identify or refer to the form that has the focus. Read-only Form object.



expression A variable that represents a Screen object.


This property setting contains a reference to the Form object that has the focus at run time.

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.

Dim frmCurrentForm As Form 
Set frmCurrentForm = Screen.ActiveForm 
MsgBox "Current form is " & frmCurrentForm.Name

If a subform has the focus, ActiveForm refers to the main form. If no form or subform has the focus when you use the ActiveForm property, an error occurs.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.