Compiler error - expected: expression 1

[Russ1005]

I get a compiler error expected: expression when executing this dlookup statement.

Any idea why?

Thanks for your help,
-Russ

? = DLookup("[avgprice]", "LOWESAVERAGECOSTWITHLABORVIEW", "[edge_model_no] = '" & [Forms]![customer_claims_detail subfrom]![model] & "'")

 

[PHV]

You wanted this ?
Debug.Print DLookup("[avgprice]", "LOWESAVERAGECOSTWITHLABORVIEW", "[edge_model_no] = '" & [Forms]![customer_claims_detail subfrom]![model] & "'")


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Russ1005]

Yes, thanks!