Calculation to automatically populate a date field

[stardog]

Using Access 2010



I think this is possible in Access, but since I have no idea how to write the calculation I am throwing this out to the experts for feedback. It involves automatically populating a future date in a form field. Here is the situation:

I have two date fields on my form that are contextually related. One is named DateRcvdinADR and the other namedActionDeadlineDate. Regarding the ActionDeadlineDate field, is there a calculation I can enter under the Control Source for this field that will automatically insert the date for a period 30 days ahead from whatever date is entered in the DateRcvdinADRfield? As it stands now the user simply enters a date in the DateRcvdinADR field, then looks at a calendar to find the date that would be 30 days ahead, then enters that future date in the ActionDeadlineDate field. Obviously there is no problem doing it this way, but to save a step is there a way that Access can make the calculation on its own and then automatically populate the ActionDeadlineDate field accordingly?

I am fairly well versed in Access, but I don't have a lot of experience writing complicated calculations. So if anyone has an answer please lay it out in simple terms. I am reasonably intelligent and intuitive person, but I ain't got no Phd in Advanced Access.

Thanks for anyone's input.



Thanks for anyone's input.

[pbaldy]

Use the DateAdd() function in the after update event of the first date textbox.

[June7]

It is not necessary to save the calc into table. Calc can be done when needed in query or form textbox. Saving the calc result requires code (macro or VBA) in some event procedure, such as AfterUpdate as suggested by Paul.

Day is default unit in arithmetic with dates so DateAdd() is not absolutely needed.

Me!ActionDeadlineDate = Me!DateRecdInADR + 30

[stardog]

Thanks for the reply, but still not sure how to state the calculation, or in which field date text box it should be written. I've attached the design view of the form and date fields to give everyone a better visual of what I am trying to do. Thanks again. Sorry for my confusion on this.

[pbaldy]

Does this help?

http://www.baldyweb.com/FirstVBA.htm

[June7]

Don't save the calc into table and the issue of how to code it is eliminated.

Do the calc in query Field row to construct a field.

Or do the calc in textbox ControlSource property.