AfterUpdate

[Guest]

I have an Access 97 database with an unbound form and several text box
controls. On one of the text boxes there is an IF statement on the
AfterUpdate event which is validating the data entered.
If a variable (calling a function) returns false set the focus back to the
same control and Exit sub. The exit sub works but the set focus does not.

Is it possible to execute a setfocus statement to the same control using the
After update event of that control? If not, is there a way around this?

Thanks
LeAnn

 

[Guest]

Try this,

when your variable returns false set the focus to another control, then back
to the one you want and then exit the sub.