Avatar of KP_SoCal
KP_SoCal
Flag 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!
Microsoft Access

Avatar of undefined
Last Comment
Gustav Brock

8/22/2022 - Mon
John Tsioumpris

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.
Dale Fye

You could also use the form_beforeupdate event.
ASKER CERTIFIED SOLUTION
Gustav Brock

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
KP_SoCal

ASKER
Thanks everyone for the feedback on this! Very helpful. I'm going with Gustav's recommendation. Have great weekend everyone!
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Gustav Brock

You are welcome!