DLookup Question

[relax4delicutfew]

I am using DLookup to search for a value called CaseID from a query, qrycombo1, but I get an expected = compile error.

DLookup("CaseID","[qrycombo1]", "RouteNumber = '" & Me!cboRoute.Value & "'")

Could anyone point me in the right direction?

Thanks
Craig

 

[kjv1611]

Try taking out the []'s

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[PHV]

DLookUp is the function returning a value, so it must be at the right side of an assignement (so the expected =).

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

 

[relax4delicutfew]

Thanks

 

[guesszoo]

Craig: I was pulling my hair out trying to get the format right for the Dlookup Method so I did a search in here on Dlookup and found your post. Even though you asked a question, your dlookup example was exactly what I needed to format mine correctly. Thanks! Your question solved my question!

Joel