Keeping up with last textbox (RESOLVED)

[GSIV]

I've searched the forums and haven't come up with anything...

I have a form with 5 textboxes and a control button for exiting by way of Form_QueryUnload. If the exit is cancelled, what is the best way to return to the last textbox that had focus?

I was thinking about assigning a variable to keep up with this when the textbox loses focus, but thought there might be a simpler way.

[James Stanich]

Variable is the easiest way to accomplish...

[Mc Brain]

Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
    MsgBox Me.ActiveControl.Name
End Sub

But it will only work as long as you don't have a command that unloads the form. If you have one... the last ActiveControl would be this command.

[GSIV]

Thanks guys!

Wow, what a quick response.