Customising 'Add New Record' Button

[Williams485]

Hello Access Forum,

I have a form that 'creates a new opportunity'. It contains a number of controls bound to fields in a table and a number of unbound fields that provide simple calculations to provide the user with feedback. The table also contains a couple of date-stamped fields (not represented on the form) that must be updated with a button I've created (using the 'Control Wizard') that will create/add the new record to the table.

The problem I'm having is that I can't seem to find out how to customise the button to say 'just before you update the record, make myTable.myField.value = Now().

I've looked at a few online resources and tried a couple of things which gave new errors (and these methods may have been running before I can walk), so I've gone back to square 1.

So, if anyone could point me in the right direction with either, how to modify the existing macro (created by the Control Wizard), OR, a way to code the control manually (I have reasonable VBA experience with Excel but not Access) so if coding will accelerate my Access knowledge then I'm happy to look at this.

Thanks in Advance...

[June7]

If the field is included in the form's RecordSource, should be simply:

Me!fieldname = Now()