Hello All
This is my first time here and “surprise, surprise” I have aproblem that I just cannot seem to figure out. I have a calibration database used for tracking the calibration statusof all measuring devices.In the tablethat supports the form there are three fields among many others that are tocontrol the dates showing on the form.The table is tbl-1-calibration1 and the date fields are as follows:
CalDate is a Date/Time field in the table and a bound fieldin the form
CalInt1 is a number field and these numbers are in a tablecalled tbl-1-CalInt. In the form theCalInt1 number is looked up using a combo box.
CalDue is a Date/Timefield(this field needs to be calculatedbased on theCalDate field times the number of months in the CalInt1 field.
The form that I use for entering data is calledfrm-1-Calibration1.
I actually had this almost working one time weeks ago and itworked perfectly for all months from 1 thru 12. Anything past 12 months the date would remain fixed at the 12 month date.
To make a long story short can someone here point me to somecode that will work. I have been allover the internet looking for a solution and have wound up back at square one still needing a solution.
Any help that you could provide would be greatly appreciated.
Thanks
WAG1