I created a form and subform. In the subform, I used dlookup to find the current price of the item. When I just open the subform alone, the current price is displayed accurately. However, when I open the main form, I get a error #Name? Everything else displays properly.
The dlookup expression is=DLookUp("[current price]","shCID","[scid]=""" & [Forms]![po detail]![scid] & """")
I cannot figure out why it works independently but not in the master form.
Thanks,
Greg