J
Joe Bloggs
Thanks for all the help so far.
I have another snag.....
On a subform I have a field called txDate, with the following control
source.... =[Forms]![frmPersonnel]![txDateMain]
This gives a date of when the persons contract is up. I have another field
in this subform that has a dropdown list of 0 to 10 for how many years
extension to the contract he has. This is called 2oe.
So that the txDate field shows the correct termination date, I want to add
the two fields together.
I came up with....:
=DateAdd("yyyy",[2oe],[Forms]![frmPersonnel]![txDateMain])
but it does not work. How can I add them succesfully?
Many thanks again for the past solutions, hopefully you will have an answer
for this!!
Cheers now
Joe
I have another snag.....
On a subform I have a field called txDate, with the following control
source.... =[Forms]![frmPersonnel]![txDateMain]
This gives a date of when the persons contract is up. I have another field
in this subform that has a dropdown list of 0 to 10 for how many years
extension to the contract he has. This is called 2oe.
So that the txDate field shows the correct termination date, I want to add
the two fields together.
I came up with....:
=DateAdd("yyyy",[2oe],[Forms]![frmPersonnel]![txDateMain])
but it does not work. How can I add them succesfully?
Many thanks again for the past solutions, hopefully you will have an answer
for this!!
Cheers now
Joe