Determining what field has focus?

firefighter2045 · November 2nd, 2007, 11:59 AM

I am trying to wright an If statement that will do different thing depending on which field in the form has focus. I don't know what code to use to determine which field has focus.

BrianWren · November 2nd, 2007, 03:29 PM

For each of the controls, add an OnFocus event that sets a global string to the name of the control. In your branching, read that global string:

Code:

Private Sub txtName_GotFocus()

    gstrFocusHolder = "txtName"

End Sub

Private Sub MySub()

    Select Case gstrFocusHolder
        Case "txtName"
        ...
    End Select

[/code]

firefighter2045 · November 5th, 2007, 10:10 AM

I think I asked the question wrong. I need to know which field had focus just before clicking on another control. I am trying to set up a filtering feature where a user can click on a control within a form and then click a filter button to preform the filter.:)

SerranoG · November 6th, 2007, 12:30 PM

When you move from one control to the next, the control that had the focus just prior to you moving the cursor is obtained by referencing

Screen.PreviousControl.Name

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

firefighter2045 · November 6th, 2007, 12:58 PM

Thanks for all the help. :)