Hello all again!
I have a sub form on my main form. On the main form I have a field called SampleDate On the sub-form I have fields called:
CNo
Age
TestDate
The user inputs 1, 2, 3 etc etc into the CNo field. Then selects an age in days from a drop down box in the age field. What I’m trying to do is populate the TestDate field with the result of SampleDate + Age.
I know its the DateAdd function but somehow its not working for me!!
Can anyone help?
Thanks in advance.
john
I have a sub form on my main form. On the main form I have a field called SampleDate On the sub-form I have fields called:
CNo
Age
TestDate
The user inputs 1, 2, 3 etc etc into the CNo field. Then selects an age in days from a drop down box in the age field. What I’m trying to do is populate the TestDate field with the result of SampleDate + Age.
I know its the DateAdd function but somehow its not working for me!!
Can anyone help?
Thanks in advance.
john
