Dlookup question 2

[knuckelhead]

I have a dlookup in my query which does Not give me an error message. however, it returns no answer. so i must have something wrong.

CPrateMH2: DLookUp("[CPrateMH]","tblCopPacking","[tblCopPacking]![PackType]='[tblFormulaMain]![PackType]'")

Packtype is a text field in both tables. I cannot use tblCopPacking in the qry; i get a "not updateable" condition. so i am using the Dlookup method to get the CPrateMH2 or manhours. tblFormulaMain is inside the qry.

do you see some obvious error?

 

[dhookom]

Try:
CPrateMH2: DLookUp("[CPrateMH]","tblCopPacking","[PackType]='" & [tblFormulaMain]![PackType] & "'")



Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[knuckelhead]

Yes. thank you so much. I will send in a donation for everyone's help lately. Knucklehead