Textbox using dlookup for Query

[CTdbdev]

Hello,



It seems people have beat this subject to death, but I'm still not getting this to work right.
I have a query that takes several columns from a products table and calculates a result into one of the query columns. In my form I'm trying to display that calculated result (cost) specific to the current ProductID on the form and query.

I think I'm close, as the following expression no longer generates #error, but it's just a blank box with each record.

=DLookUp("[KitCost]","[KitCostQ]","[ProdPN]= ' " & [Forms]![ProductF]![ProdPN] & " ' ")

Regards,
Alex

[June7]

Don't put spaces around the apostrophe.

=DLookUp("[KitCost]","[KitCostQ]","[ProdPN]= '" & [Forms]![ProductF]![ProdPN] & "'")

Is ProdPN a text type field? If it is number then don't use the apostrophes.

[CTdbdev]

Oh, oops. I put the spaces in there to make it easier to read when reviewing code.
It works now, Thanks!