Access Dlookup Matching Problem

[skbrede]

Has anyone else had trouble with Access Dlookup function ? It works fine with a numeric matche criteria, but will not work with a "text" compare!! Would appreciate any help anyone has. If not is there any other way to read a field from a table directly into a local variable ??

[puppydogbuddy]

Text criterion have a different syntax. see this link for details and examples:

http://support.microsoft.com/kb/208786

[missinglinq]

Also note that the same syntax is used for other similar functions such as DCount() and DMax().

Welcome to Bytes!

Linq ;0)>

[skbrede]

Thank you both !! Problem solved

[missinglinq]

Glad we could help!

Linq ;0)>