Add Sno with Date, Add 180 days added to previous record
I have an access form with few subforms.
There is a date in the main form. I want to add a Sub Sno with date in to the subform. Below is the details.
First appointment date (Mainform)
Add first record. main form date+3months. There is a field to record their attendance in subform.
Add Second record. subform attendance date+6 months
Add third record. subform attendance date+6 months
I managed to add the first record with 3 months added.
When the 2nd and 3rd 6months from the attendance date is creating problem with other records if I close and open again. (i.e. adding 6 months to the other record's attendance