Create Suspense Date

B

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?
 
P

PC Datasheet

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

Rick B

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