Form.ActiveControl (Access)
You can use the ActiveControl property together with the Screen object to identify or refer to the control that has the focus.
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. The following example assigns the name of the control with the focus to the strControlName variable.
Dim ctlCurrentControl As Control
Dim strControlName As String
Set ctlCurrentControl = Screen.ActiveControl
strControlName = ctlCurrentControl.Name