Help with DLookup Syntax

[robboll]

Access 2003
If I put in a test value, this works in the Immediate Window:
DLookup("[Template]", "[Templates]", "[TemplateName]= 'Signature'")

If I have a ListBox (i.e., List97) to replace 'Signature' -- what is
the syntax? Here is what I have:

Dlookup("[Template]", "[Templates]", "[TemplateName] =" &
Me!List97.Value)

Returns an error:
Expected: =

Thanks for any suggestions

RBollinger







? Dlookup("[Template]", "[Templates]", "[TemplateName] =" &
'Me!List97.Value')
? DLookup("[Template]", "[Templates]", "[TemplateName]= 'Signature'")

 

[Al Camp]

Assuming MultiSelect = None...
Try...
Dlookup("[Template]", "[Templates]", "[TemplateName] =" & List97)
I tested... should do it.

Suggestion: use object names that make sense to you... ex... lstSignature.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions