More DLookup Help Needed!

[slrphd]

I am still struggling with the implementation of the Dlookup() function. Maybe someone can help me with a couple of basis questions. Based on a few of the tests that I have done, it seems as if the criteria need to match numeric data. The one simplistic example I have gotten to work uses numeric values in the criteria. I tried to mimic that example using text criteria but no glory. So, do the criteria have to be numeric? So far, all other sources of information have been silent on this issue.

Question #2: are my chances of success better if I implement Dlookup in code rather than using the expression builder on the property’s sheet?

Thanks.

 

[pbaldy]

Here's a good resource on these:

http://www.mvps.org/access/general/gen0018.htm

 

[slrphd]

Paul,
Thanks for the tip. The webpage provided additional information on use and formatting that I lacked.