Afterupdate event

T

Trever B

I need help on this item

I do a check on the data someone has entered.

If it does not pass message box appears yes to renter no to cancel input

not sure what code will do following:-

1. If yes (re-enter data) need to send back to subform beginning of
field (Not next field)

2. If No (Cancel) need to cancel entry on sub form .

Hope you understand this

& thanks
 
T

tina

exactly what you're doing it not clear, but as a general direction:
validate data on the BeforeUpdate event, *not* the AfterUpdate event. you
can validate data in a specific control before the user leaves that control,
by using the control's BeforeUpdate event; or validate data in one or more
controls in the form before the user leaves that record, by using the form's
BeforeUpdate event.

hth
 
T

Trever B

Thanks Tina Have changed it to before update but mu problem still stands:-

If it does not pass validation in before update I give user the option to:-

go back & change information in field (I need them to go back to the start
of the sting without moving on to next field within subform.

or

cancel field by me.undo
 
Top