Before Update vs After Update

[Jake F]

I have a continuous form that is locking. A yes/no option box is the only
updates done to the records. I have the option box running on after update
but am wondering if putting the coding to update the yes/no (also adds
time/user stamp) on before update. Before I kick this out to the users is
there anything anyone knows that will be wrong in doing it this way? Thanks.

 

[Allen Browne]

You need to do this in Form_BeforeUpdate.

It makes no sense to dirty the form again (repeatedly) the instant the
record is saved.

 

[Jake F]

Instead of having it affect on the option box before update, do the form
before update?

 

[Jake F]

Also would the repeated dirtying cause the record locks?

 

[Allen Browne]

Yep.