HillTJ
To train a dog, first know more than the dog..
- Local time
- Today, 05:48
- Joined
- Apr 1, 2019
- Messages
- 731
Hi, I'm working on My calibration database. I have a main form containing a ComboBox "Frequency" within it is FrequencyID, Frequency_Desc. (Lookup contains "Annual", "Monthly",bla bla...On the mainform is a linked subform for each Equipment Inspection record. It contains a field "Anniversary" & "Actual_Date". On the first record, "Anniversary" will be the issue date & "Actual_date" will be the actual date that the calibration was conducted (we have a 15 day grace on the date).Subsequent records will be populated with "Anniversary" from the previous record + "Frequency" using the DateAddFunction & a case statement to select correct frequency. I do his because, under certain circumstances the user may be required to select a different "Frequency" for a period, rather that the alternative of working from the original date. Following this, my intention is to export that record as a task to my outlook Calendar. I've never 'Carried forward' a record before, nor exported to outlook. Does this sound a reasonable approach? Appreciate any feedback before I get in too deep!!.