How do I set the value of a form control in a macro or VBA procedure?

[Petrol]

I have a form which allows the user to make changes to a table through the underlying query. One field in the table and query is "Date_updated".

At the bottom of the form are two buttons - "Confirm and exit" and "Undo changes". If the first is pressed, before saving the record I want to set the [Date_updated] field to today's date, but I can't see how to do this. Can anyone please help?

[nabila06]

assuming that your form is associated to the table, you may wanna try this:

Confirm_and_exit_Click()
Date_updated = format (now, "dd mm yyyy")

DoCmd.RunCommand acCmdSave

'the record will be: 12 05 2014
End Sub