MS Access - BeforeUpdate for form validations
Posted on 2007-10-01
In an Access database, I am trying to use the BeforeUpdate event, specifically the Form_BeforeUpdate sub, to validate the row, then set Cancel if it fails so the row is not posted to the DB. The problem is in addition to being run before the row is posted, Form_BeforeUpdate is run after the field is updated, and I can't tell if the user updated a field & tabbed out, or if the user attempted to leave the row & post it to the DB.
How can I tell if the Form_BeforeUpdate is being run as after as field level validation or as a row level validation?
Thanks in advance,