GoToControl Not Working

[NMiller007]

I am using a GoToControl in an Access macro to validate a field. The macro is run from the BeforeUpdate of the field (I tried AfterUpdate as well). The macro checks the condition, if true, I have a cancel event. Then a message box, that does pop up. Then I added a GoToControl to move back to the bad field.

Whether I tab out of the field or click on another field, after the message box pops up, I am in the new field.

What am I doing wrong?

 

[TheAceMan1]

Hoe are ya NMiller007 . . .

You shouldn't need gotocontrol!. disable/remove the line. Focus should stay where it is . . .

See Ya! . . . . . .

 

[TheAceMan1]

hit submit too soon . . .

that is Focus should stay where it is if you cancel the event! . . .

See Ya! . . . . . .