Update date control

[air4jmh]

Ok, I've looked around at several threads and didn't get an answer to my question.

I have a form with a date control and would like it to auto update with the current date when the save button is clicked.

I currently have the following code but it is not changing the record.

Private Sub Save_Changes_Click()
On Error GoTo Err_Save_Changes_Click
Me.[Last Update Date].Value = Date

I can give more info in needed.

 

[dylan_dog]

your_control.Value = Date
Me.Refresh

It is much easier if you don't use spaces i control names. Use underscore for instance.

 

[air4jmh]

Thanks Dylan but that didn't change anything.
is there a need to delete the table data somehow first? would that help?

 

[ypma]

Your code works when i apply it to the forms On data change event ! You could try other events if you wish for the update to activate on visits to the record , such as the on current event .
Hope this is of use to you
Regards

 

[air4jmh]

thanks for the reply. We got it figured out. I had replaced the button and didn't move the code to the new button.