Date fields on a form

[jumstead]

I need to have a date field on a form that automatically selects the current
system date whenever the record is updated, not just viewed. I already have
a field that automatically enters the current date when a record is added,
but I need a second field to track updates by record..

 

[Marshall Barton]

I need to have a date field on a form that automatically selects the current
system date whenever the record is updated, not just viewed. I already have
a field that automatically enters the current date when a record is added,
but I need a second field to track updates by record..

Use the form's BeforeUpdate event:

Me.thefield = Date

 

[BruceM]

You could use the form's Before Update event. Maybe something like:

Me.DateField = Date

Substitute you actual field name for DateField, of course.