Remove/add dates in a form by entering other dates 1

[mobile2]

I have a form with 4 date fields. The fields are updated in the following order "Active Date", "First Contact", "Last Contact", "Next Contact". I have already used a useful piece of advice for entering a "First Contact" date 7 days after the "Active Date" (thread705-441796). I would now like to remove the "First Contact" date once a "Last Contact" date is entered and then add a "Next Contact" date that will be 3 months after the "Last Contact". The "Next Contact" date may not always be 3 months after the "Last Contact" and would have to be amendable. These dates will activate different reports.

 

[BillPower]

In the Last Contact "After Update" event:

me![First Contact] = Null
me![Next Contact] = DateAdd("m", 3, me![First Contact])

Hopefully, should do it.

 

[BillPower]

That's twice I've done this today. I think it's correct this time!

In the Last Contact "After Update" event:

me![First Contact] = Null
me![Next Contact] = DateAdd("m", 3, me![Last Contact])

Hopefully, should do it.