Afterupdate event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top