<div>
That is actually what I thought, but I found the problem: this form was developed by someone else and it has some stuff that I did not know was there. One of the fields was calling a macro on the &quot;After Update&quot; event, and that macro had RunCommand / SaveRecord in it, so it was that macro that was triggering the call to the form's Form_BeforeUpdate() sub. It made it LOOK like changing &amp;&nbsp;tabbing out of that field was calling Form_BeforeUpdate().<br />
<br />
Thanks again,<br />
parkerea
</div>


That is actually what I thought, but I found the problem: this form was developed by someone else and it has some stuff that I did not know was there. One of the fields was calling a macro on the "After Update" event, and that macro had RunCommand / SaveRecord in it, so it was that macro that was triggering the call to the form's Form_BeforeUpdate() sub. It made it LOOK like changing & tabbing out of that field was calling Form_BeforeUpdate().

Thanks again,
parkerea

<div>
<div class="content wysiwyg-content">
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 &amp;&nbsp;tabbed out, or if the user attempted to leave the row &amp;&nbsp;post it to the DB.<br />
<br />
How can I tell if the Form_BeforeUpdate is being run as after as field level validation or as a row level validation?<br />
<br />
Thanks in advance,<br />
parkerea
</div>
</div>


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,
parkerea

MS Access - BeforeUpdate for form validations

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.