Help in DLOOKUP Function

[root2007]

Hi folks,

Can you please help with my dlookup function. I wrote this VB

txtPlateNo = DLookup("DesignatedTruck", "Driver Info", "DriverName = " & txtDriverName)

and the error is "syntax error (missing operator) in query expression"

What will I do?

 

[John Big Booty]

Given that your matching on a string that string needs to be enclosed in quotes, try;

txtPlateNo = DLookup("DesignatedTruck", "Driver Info", "DriverName = [COLOR="Red"]'[/COLOR]" & txtDriverName [COLOR="Red"]& "'"[/COLOR])

 

[John Big Booty]

... check this link for other types of criteria.

 

[root2007]

Thanks John for your help. More Power and God bless!