auto insert date when anothe field is changed.

[Pauly78]

On my form have a status field with about 7 options to choose from a combo box, i have these values set in another table. What i would like is for my other field, which is a date, to automatically change whenever the status field is changed. So i know how long ago the status field was set. So basically if i change the status to complete i want the date to then set the date and time now.
Can anyone help?
Thanks

 

[pbaldy]

You can set the date field in the after update event of the combo.

 

[Pauly78]

ive already tried to do this and nothing happens, could you tell me the code i have to put in?
The field name that i have the options in is JobStatus and the field with the date i want to populate is called StatusDate
Ive tried a few different codes from posts i have found but most of them are to set the date when a specific word is selected, such as resolved or whatever. I want mine to change the date whenever the status is changed at all.

 

[pbaldy]

Me.StatusDate = Now()

 

[Pauly78]

Thank you!! it works fine

 

[pbaldy]

Happy to help!