Fill in a field automatically if another is changed

[ppataki]

Dear All,

I am struggling with an issue in Access:

Is it somehow possible with a query or a form that if one field is filled in with a specified character string (like "OK"), another field in the same record gets updated automatically (eg to today's date)?
(so not only shows it but gets really updated phisically)

I need this function to be able to track certain changes

Your help would be very much appreciated!

 

[rainman89]

yes. you can do this in the before update event of a textbox.

the code would look soemthing like this

if (me.yourtextboxname="ok") then
me.yourdatefield=now
else
end if

 

[ppataki]

Hello,

Thank you it works fine!!
(however I put that to AfterUpdate event)