DateAdd Function

  • Thread starter Thread starter JC Barry
  • Start date Start date
J

JC Barry

I have been able to use the DateAdd function to
successfully display the date I want (14 days from the
current date) in my form, however when I save the record,
the value in this control is not carried over into my
table. How can I fix this??
 
Set the Control Source property of the text box to the name of the field
where you want it stored.

Use the BeforeInsert event procedure of the form to write the date into the
control:

Me.[SomeField] = DateAdd("d", 14, Date)
 
Back
Top