Roll over dates

[Darkwater]

I'm wondering if the following is possible?

I have a Review Date field where a client needs to be re-assessed either on a monthy, bi-monthly or tri-monthly basis. I suspect I could create a table to store successive review dates and include it as a sub-form on my main form but I am guessing that it might be too cumbersome and not as efficient as some of you guys might do it.

Would it be possible therefore to have the Review Date roll over to the next review date at a given interval after say some kind of command button or tick box is clicked?

Just a thought, but if there is anyone out there that could advise me I would appreciate it.

Regards
Doug

 

[mhartman]

Hello:

On the FORM OPEN or CURRENT event of your form you could test for the value of the date. Then increase the date based on your established criteria, 5 days, 10 days etc.

Regards
Mark

 

[Darkwater]

Thanks for that Mark. Apologies for delay in responding been too busy pullin' me hair out with other Access related stuff.

Doug