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!
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!
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.
In the After_update event of field1
field2 = "complete"
but it could be a bit more complex..
Give some more info.
I would also use the BeforeUpdate event - and ignore an empty input:
Private Sub Field1_BeforeUpdate(Cancel As Integer)
If Not IsNull(Me!Field1.Value) Then
Me!Field2.Value = "Completed"
End If
End Sub
Premium Content
You need an Expert Office subscription to comment.Start Free Trial