Form date field that can trigger other date fields??

[cratebug]

Hello ALL!

Working in MS Access 2010. Data must be entered and updated in Access only. Trying to figure out if it's even possible to auto populate dates in multiple fields in a form that are triggered when I enter ANY date in a primary date field on the form. I have close to half a dozen fields I'd like to do this for but here are a couple of the fields I'm working with:

Re Insp Date 90 Day Notice(Form field to be triggered and show a date 90 days prior to the trigger date)
Re Insp Date 60 Day Notice (Form field to be triggered and show a date 60 days prior to the trigger date)
Re Insp Date (Trigger date)

What I'd like to do is enter values in the "Re Insp Date" field (in the form) and have it trigger/auto-fill/auto-populate the "Re Insp Date 90 Day Notice" so that it shows the date 90 days prior to the "Re Insp Date" and the "Re Insp Date 60 Day Notice" so that it shows the date 60 days prior to the "Re Insp Date"........all this, and have it auto-update the queries and tables its linked to.

I've tried looking online and in instructional material to see if there is a formula, equation, macro, an expression or VBA coding that I can use to execute this but am having no luck.

The MAIN OBJECTIVE is to have the the linked query and table update automatically. Possible?? Perhaps some type of "work-around" I can incorporate?? Any suggestion would be appreciated.

I have tried doing =([Re Insp Date])-90 but no dice...

Help!

 

[MarkK]

Calculate the results you need, when you need them, from your raw data.
In a query, you can create a field like . . .

Notice90Day: ReInspDate - 90

In code you can do . . .

Me.tb90DayNoticeDate = Me.ReInspDate - 90

Also, I've never heard of that "no dice" error you talk about. Can't troubleshoot that.

 

[cratebug]

Calculate the results you need, when you need them, from your raw data.
In a query, you can create a field like . . .

Notice90Day: ReInspDate - 90

In code you can do . . .

Me.tb90DayNoticeDate = Me.ReInspDate - 90

Also, I've never heard of that "no dice" error you talk about. Can't troubleshoot that.

Thank you MarkK...I will try this and report back. :thumbsup: