Update date field

[Loucorea]

I have a date field in a form called Activity Date. I wish to have it update the associated table field to todays date() when ever it is opened. It will show the correct date on the form but not update the table field. I'm sure I'm missing something simple but can't figure it out.

[pbaldy]

Is the control on the form bound to the field in the table (and the form bound to the table)?

[Loucorea]

Is the control on the form bound to the field in the table (and the form bound to the table)?

The control is set to the table name. It will display the value in the table when opened. I wish to have it changed to todays date each time it is opened. Date() is set to the default value and it is set to that for new records.

[alansidman]

Look at this link

http://www.datawright.com.au/access_..._in_access.htm

[Loucorea]

Thank you! Only needed to track date changed so just used now() option. Wroked great.