Calculate future date in access 2007

[dvora123]

On my form, I need to be able to have Access autocalculate a 3-month followup:

This is what I have so far:

My field "Web Reviewed Date" and an unbound text box for 3-month follow-up (next review date in my main table)

In the unbound textbox control source, I have put the code =DateSerial(Year([Web Reviewed Date]),Month([Web Reviewed Date])+3,Day([Web Reviewed Date])).

This works just fine.

But I cannot figure out how to tie the unbound text box into my main table for reporting and querying. Please help!

[MMcCarthy]

On my form, I need to be able to have Access autocalculate a 3-month followup:

This is what I have so far:

My field "Web Reviewed Date" and an unbound text box for 3-month follow-up (next review date in my main table)

In the unbound textbox control source, I have put the code =DateSerial(Year([Web Reviewed Date]),Month([Web Reviewed Date])+3,Day([Web Reviewed Date])).

This works just fine.

But I cannot figure out how to tie the unbound text box into my main table for reporting and querying. Please help!

In the form open event you will need to check the system date against this date.

[missinglinq]

Actually, Access has a function for adding to dates called, oddly enough, DateAdd().

= DateAdd("m", 3, [Web Reviewed Date])

is all you need.

As to "tying it into your main table" you really shouldn't. Instead, you should simply use the same function in a calculated field in a query, using this calculated field in forms/reports when needed. In a blank field in the Query Design Grid enter

FollowUpDate: DateAdd("m", 3, [Web Reviewed Date])

Then in forms/reports simply refer to FollowUpDate, comparing it, as Mary said, to the computer's system date. Welcome to TheScripts!

Linq ;0)>