Date fields on a form

  • Thread starter Thread starter jumstead
  • Start date Start date
J

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..
 
jumstead said:
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..
Click to expand...


Use the form's BeforeUpdate event:

Me.thefield = Date
 
You could use the form's Before Update event. Maybe something like:

Me.DateField = Date

Substitute you actual field name for DateField, of course.
 
Back
Top