I'm sure it has something to do with the address of the criteria.
I have a form with a subform and and within that subform I perform the following
Me.PaymentFeeFld = DLookup("PaymentFee", "DdSchedules", "[DdSchedId] = " & DdSchedId)
MsgBox "The PaymentFee = " & Me.PaymentFeeFld & " The...