Rolling Dates.

[Floyd Forbes]

I have a Subform base on a query that's on a main form. On the main form
I also have a Textbox for entering number of days. The Subform
has four Text boxes, frmName, frmCode, frmTime and frmdate. How can I
use a commcand button to look at the text box on the main form to check for
number of days. If 5 is in the text box I would to like five days to show
in
the Subform. Can MS-Access programatically roll the dates forward?

 

[Michel Walsh]

Hi,


You can use DateAdd( ), see help file, to add (or subtract) date/time
intervals to date_time values.

Take a look at http://www.mvps.org/access/forms/frm0031.htm to have an
extended tableau of different syntaxes to use in order to reach other
controls.


Hoping it may help,
Vanderghast, Access MVP