Return to invalid textbox after update
Posted on 2013-06-11
I have this code in the AfterUpdate event of a from textbox:
If Not IsNumeric(Me.txtTransactionsProcessed) Then
MsgBox Me.Controls("lbltxtTransactionsProcessed").Caption & " must be a number.", vbInformation, "Pricing Scorecard"
Me.txtTransactionsProcessed = Null
I'm simply validating that the user's entry is a number. After the message displays, the cursor moves to the next textbox in the form.
What I want is for the textbox I just validated () to keep the focus after the message is displayed. Thanks