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.
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
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

ASKER

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