Add future date with a button

C

Chad

Hi,

I have a "last calibration" field on a form that is updated through
the calendar control. Below that, I have a "Next Calibration Due"
field that I would like to populate 1 year forward from the last
calibration field. I used the expression builder "=DateSerial(Year
([StartDate]),Month([StartDate])+12,Day([StartDate]))" which works,
however that field remains blank in the report.

I thought perhaps just adding a button beside the "next calibration"
field to calculate would be easiest.

Thanks in advance,

Chad
 
C

Chad

Take a look at the DateAdd function.  You can even use this function inthe
Control Source of your text box where the calculated date is to be entered.

-----
HTH
Mr. Bhttp://www.askdoctoraccess.com/
Doctor Access Downloads Page:http://www.askdoctoraccess.com/DownloadPage.htm

Chad said:
I have a "last calibration" field on a form that is updated through
the calendar control.  Below that, I have a "Next Calibration Due"
field that I would like to populate 1 year forward from the last
calibration field.  I used the expression builder "=DateSerial(Year
([StartDate]),Month([StartDate])+12,Day([StartDate]))" which works,
however that field remains blank in the report.
I thought perhaps just adding a button beside the "next calibration"
field to calculate would be easiest.
Thanks in advance,

Thanks so much! This works much better. I created a query with a
"period (1 default, hidden) value with the DateAdd function and it
works perfectly.

Thank you!

Chad
 

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

Top