You also have to be careful with the Name property of a control. If the control is unbound, as this one is, the Name property cannot be the same value as any field that is bound to the form. This mistake usually happens when you reuse a control that was added by the wizard or by dragging a field from the field list since in both those cases, Access gives the control Name the value of the bound field. So, if you originally had a bound field named [Amount] and then changed the expression to this Dlookup() and didn't change the control name, there would be a conflict.
=DLookUp("[Amount]","[tblD
You also have to be careful with the Name property of a control. If the control is unbound, as this one is, the Name property cannot be the same value as any field that is bound to the form. This mistake usually happens when you reuse a control that was added by the wizard or by dragging a field from the field list since in both those cases, Access gives the control Name the value of the bound field. So, if you originally had a bound field named [Amount] and then changed the expression to this Dlookup() and didn't change the control name, there would be a conflict.