Originally Posted by
cbuechner
I have a query "tooling_cost", and it has a field Tool/Gauge_Cost or SUMofTool/Gauge_Cost. In a form "Tooling_Markup" I want to add a text box (in the header) value results of the query meets the criteria
Tooling_Cost.Part=Forms!Tooling_Markup!Part
Not sure why I keep getting error.
Give a try to this expression:
Code:
=DLOOKUP("ToolCost","Tooling_Cost","Part=" & [Part])
where "ToolCost" = the name of the field Tool/Gauge_Cost.
If the Part is not numeric, have to use single quotes as seems below:
Code:
=DLOOKUP("ToolCost","Tooling_Cost","Part='" & [Part] & "'")