Event on leaving a record

[L'apprentis]

This is, I think a very easy question: What would be the apropriate form event to use when leaving a record on a single form (When you press next record for example)

 

[RuralGuy]

Sorry, but there is no "about to leave a record" event unless you have changed a field, then the form BeforeUpdate and AfterUpdate events fire.

 

[L'apprentis]

Cheers Rural guy, I just though of doing what I wanted to do by using a command button. I can use the click event of the command button where if my condition applies then "DoCmd.GoToRecord , , acNext" Else
message box "blah blah blah"

 

[RuralGuy]

That's one way to skin a cat. It should work.