Hi Folks,
I'm after some direction: On my form I have a date field called 'date of calibration' . I also have a combo box with the following two options:
"every 6 months"
"every 12 Months"
What i'd like to do (for example) is enter a date in the 'calibration date' field. I then want to select a schedule (either 6 months or 12 months) from the combobox.
If i select '6 months' then 6 months is added onto the calibration date and shown in a text box, likewise if '12 months' is added then that is added onto the date of calibration.
I know in reality this seems superfluous, because you can easily (mentally) add 6 or 12 months to a given date, but think would be good functionality for my DB.
Any pointers would be appreciated.
Cheers!
I'm after some direction: On my form I have a date field called 'date of calibration' . I also have a combo box with the following two options:
"every 6 months"
"every 12 Months"
What i'd like to do (for example) is enter a date in the 'calibration date' field. I then want to select a schedule (either 6 months or 12 months) from the combobox.
If i select '6 months' then 6 months is added onto the calibration date and shown in a text box, likewise if '12 months' is added then that is added onto the date of calibration.
I know in reality this seems superfluous, because you can easily (mentally) add 6 or 12 months to a given date, but think would be good functionality for my DB.
Any pointers would be appreciated.
Cheers!