Here is the formula I am using, it is been put into a unbound text box in the control source. It is a simple calculation of two years from the date of purchase.
=DateSerial(Year([FIELD1])+2,Month([FIELD1]),Day([FIELD1]))
If there is no purchase of this item, I want it to read, "NO PRODUCT"
Right now the box is showing #Type!, when there is no information in FIELD1 to pull from.
Any assistance would be greatly appreciated.