I have a form with a continous subform in it. The subform consist of a final date and the rest of the field are renewal date its suppose to look like this
Final = 01/02/2000
renewal = 01/31/2002
Secondrenewal = 01/31/2004
the renewals are always suppose to be at the end of the month and every two years from the final date. I just want the users to put in the final date and then have the fields populate themselves (no repeating values) automatically exactly like the example above is this possible???
I did some reasearch and I was thinking I could just have the final date and the firstrenewal date in the query have this dateserial code
=DateSerial(Year([FIRSTRENEWALDATE])+2,Month([FIRSTRENEWALDATE]),Day([FIRSTRENEWALDATE])). I was thinking of setting this up in a query. then placing it in my subform which is continous.