Update date in three different fields based on date in another field

[spudracer]

I've got three fields with three different dates, all based upon one or the other for when reports should be turned in where.

What I want to do, is have it set up so that whenever the report is due, the dates will be automatically entered, and updated if the due date changes.

I know that in Access 2003, you could use the SetValue in a Macro, but I don't believe (but haven't seen anything that works the same) that option exists in 2007, and I believe that creating the code in VBA would probably be "easier."

If there's another topic dealing with this, I must've not been searching using the appropriate keywords, and for that I apologize.

Again, I'm using Access 2007.

 

[vbaInet]

Please elaborate. The dates would be automatically entered on the report or in text boxes on your form from which the report is called?

If you're doing such a calculation you wouldn't need to save the date values.

 

[spudracer]

The dates are needed to be saved in the individual records. They are as follows

Location 1 = 40 days from due date
Location 2 = 30 days from due date
Location 3 = 10 days from due date

This is all for a form (frmReports), which (correct me if I'm wrong), if done right will save to the table?

 

[vbaInet]

Are there only 3 locations and would that never change or at least not frequently?

Have a look into the DateAdd() function and see if this meets your needs.

If done from where exactly?

 

[SOS]

I still wouldn't update the table with this. I would use a QUERY which calculates them and use that QUERY for the report instead of the table (a query can be used just like a table wherever a table can be used).

 

[spudracer]

vbaInet - Well, the dates change depending on the report, there is approx. 100-130 different reports, all with different dates.

SOS - Would the Query work similar to a macro? Right now, I've got all my forms set to pull from Queries, so if I have to add a couple of fields into the query for it to calculate, I'm fine with that. I'm just trying to semi-automate the process to make it easier for others in my office to use this form.

UPDATE - After mentioning the Query, I figured it out. Works the way I want it to without the complex code. Thanks, to the both of you for your help!

 

[vbaInet]

Great stuff!! Thanks to SOS.