Create Suspense Date

[bertc]

I want to create a suspense date based upon a anticipated completion date in
my database. Is there a way that the suspense field can automatically be
filled in based upon the anticipated completion date?

 

[PC Datasheet]

Put the following code in the AfterUpdate event of CompletionDate:
Me!SuspenseDate = DateAdd("d",-90,Me!CompletionDate)

 

[Rick B]

One post per issue please. No need to repost if you don't get an answer in
an hour or so.

 

[bertc]

Do I do that in a query or a form? Is that a macro or expression?