simple SetFocus

[markjkubicki]

how come at the end of the following code (which executes without error), i don't find the curser blinking and waiting in txtLeadTime2 ?
actually, i'm not certain where it is waiting; i don't see it blinking anywhere (!?)



...
Response = MsgBox(vPrompt, vbInformation, "INVALID DATE RANGE")
Me.txtLeadTime2 = ""
Me.txtLeadTime2.SetFocus
...

as always,
many thhanks in advance
mark

[pbaldy]

What event is this code in?

[markjkubicki]

it's in the after update event

[pbaldy]

The after update event of...?

If it's that same control, you'd be better off using the before update event and

Cancel = True

Typically the before update event of a control or form is used for data validation. To do what you're doing, you likely need to set focus somewhere else and then back where you want it.

[markjkubicki]

gotcha
thnx

[pbaldy]

No problem; post back if you get stuck.