I have a main form titled
"ForCalculationEntry" with the [Item] field and a [Receive Date] field.
This is an entry form.
I also have a subform titled "PO1 subform2" with the field [Promised Date].
This form reports the promised date associated to the Item entered in the "ForCalculationEntry" from.
I am attempting to take the difference of both dates and let me know if it is late or on time.
I attempted the following:
=IIf(Abs(DateDiff("d",[Promised Date],[Receive Date]))>5,"Part is late, Click Below to Notify Buyer","Part Arrived On Time")
I get this error message: #Name?
I also attempted the following:
=IIf(Abs(DateDiff("d",[Forms]![PO1 subform2]![OriginalPromisedDate],[Forms![ForCalculationEntry]![Receive Date]))>5,"Part is late, Click Below to Notify Buyer","Part Arrived On Time")
with the same error message.