Show Last Date

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I have a form that is a sub-form on another form. Anyway on that form it has
a date field that by default shows todays date.
After entering a record this date field then again show's todays date.
However I sometimes set the date myself to another date, but of course when
the next record is entered it sets it back to todays date. I want it to not
do this when I manually set it to whatever date. I do want it to default to
todays date normally.
I tried using this code to accomplish this, but it sets the date after the
update to 12/30/1899
This code is activated on the after insert event on the form itself.
What can I do to make it work ?

Thanks,

Dave

Me!WorkDate.DefaultValue = Me!WorkDate
 
Default value expects a "string expression", so try this:

Me!WorkDate.DefaultValue = """" & Me!WorkDate & """"
 
Back
Top