Link to home
Start Free TrialLog in
Avatar of KP_SoCal
KP_SoCalFlag for United States of America

asked on

Access Form Operations: "after update" event, apply a specific value to a field for the record that was updated...

In Access 2010, I have a form where I'm updating records. Every time I update "field1", I'd like to automatically change the value in "field2" to 'complete.'

I appreciate any feedback as to what the most efficient method is for this task. I won't be able to test any responses until Monday. Thanks in advance!
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Well it could be easy as
In the After_update event of field1
field2 = "complete"
but it could be a bit more complex..
Give some more info.
You could also use the form_beforeupdate event.
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KP_SoCal


Thanks everyone for the feedback on this! Very helpful. I'm going with Gustav's recommendation. Have great weekend everyone!
You are welcome!