What's the opposite of the "On Current" event?

[vangogh228]

I use On Current a lot... sometimes to make sure certain values are null when I come back to a record, for example. But... can I do the same thing as I am LEAVING a record?

I have made it so a number of records in a continuous subform can be checked (bound checkbox), then a button is selected that creates a report based on a query, using the checked field in the query as a qualifier. I added code to the end of the Click event the puts the checkboxes back to 0 through an update query... and it works!! But... I need to run this query as I am leaving a record... in the case that I select then scroll instead of running the report.

Any help is greatly appreciated!!

Tom

 

[RuralGuy]

Unfortunately there is no OnRecordExit event but maybe this link will work for you:
How to programmatically implement a RecordExit event in Access 2002

 

[vangogh228]

Thanks! I'll note that and try it.