ACC2000: Previous/ActiveControl Name Property Not in Auto List

RESOLUTION

To refer to the Name property of the Screen.ActiveControl or Screen.PreviousControl, you should create a variable and assign the name of the control to that variable. For example, the following sample piece of code is one way you could refer to the active control's name:

Dim ctlCurrentControl As Control
Set ctlCurrentControl = Screen.ActiveControl
  If ctlCurrentControl.Name = "txtCustomerID" Then
         ' Do this.
  ElseIf ctlCurrentControl.Name = "btnCustomerDetails" Then
         ' Do this.
End If
				

NOTE: Code that refers to Screen.ActiveControl or Screen.ActiveForm does not work correctly when called from the Immediate window because the Immediate window has the focus at that time. If no control has the focus when you use the Screen.ActiveControl property, or if all of the active form's controls are hidden or disabled, a run-time error occurs.