Update a field to Now() when a button is clicked

[JanesC]

My form has a field for 'date_completed' I'd like it to be updated to Now() when a button is pressed. Thanks

 

[jamie13]

All you have to do is simply make a button. Go to onclick into the coding section and and use date_completed = now().
when ever the button is clicked the current date will appear in the date completed field

 

[MisterC]

I assume there is a textbox on your form that is bound to a field in the underlying data source. In the Click event of the button:

    Me.FieldName = Now()
    Me.Refresh

where FieldName is the name of the field you want to update.

 

[JanesC]

Thanks jamie13 it works like a dream!

 

[JanesC]

Thanks also to MisterC that works as well. You learn something new every day.