DLookup question 1

[Eprice]

I want to use DLookup for two criteria. First will be AutoNo = AutoNo, a field in a table to match the field on the form and where another field HWType = "Monitor". I tried this but get nothing in return.
DLookup("[SerialNo]", "tblHardware", "[AutoNo] = " & [AutoNo] & [HWType] = "Monitor")

Thanks, Lisa

 

[dhookom]

Try:

DLookup("[SerialNo]", "tblHardware", "[AutoNo] = " & [AutoNo] & " AND [HWType] = 'Monitor'")

Duane
Hook'D on Access
MS Access MVP

 

[Eprice]

That gives me #Name?. This is on a subform if that helps.
Lisa

 

[Eprice]

I forgot the equal sign, yes it does work. Thanks Duane.
Lisa

 

[dhookom]

Did you include the "=" since this is probably a control source property?

If this is a text box, what is the Name property of the text box? It can't be the Name of a field in the subform's record source.

What is the actual expression you tried?

Duane
Hook'D on Access
MS Access MVP

 

[Eprice]

I did forget the = sign but as soon as I realized that, I responed back and gave you a star. Thanks so much.
Lisa