Originally Posted by
CJ_London
You need to use the form before insert event, not after update event - (after is too late (record already posted) and update means it will change every time you change anything on the form, whilst insert only occurs the once)
the code is simple
me.ReviewDate=me.ContactDate+30
have to question why you need to store this, easy enough to use a query to determine it as and when required
Also why 30 days? if the contact date is a Thursday or Friday, in 30 days time the review date will be a Saturday or Sunday. Unless you are a 7 days a week operation, would have thought 28 days would be more appropriate. If you leave it as 30 days, Monday you have double the number of reviews to do from those not done on Saturday/Sunday, whilst Tuesday you will have no reviews