DateAdd Function

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??
 
A

Allen Browne

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Countdown macro - display settings 2
Display weeks from a Milestone 0
DateAdd Problems 2
Adding data to MS Access from csv file 0
Descenders clipped 0
DateAdd problem 2
query on date 1

Top