DLook Syntax Help - for Ken Snell

DLook Syntax Help - for Ken Snell

Post by Dan » Sat, 31 Jul 2004 03:06:28


Hi Ken:

Thank you but is still giving me this message:

Application can't find the field '|' referred to in your
expression

Thaks,

Dan
message

in a
.
 
 
 

DLook Syntax Help - for Ken Snell

Post by Ken Snel » Sat, 31 Jul 2004 08:20:05

Please stay in the same thread. Reply posted there.

--

Ken Snell
<MS ACCESS MVP>

 
 
 

DLook Syntax Help - for Ken Snell

Post by Dan » Sat, 31 Jul 2004 08:50:31

Hi Wez:

Still the same ... I took out the quotes...I am thinking
stupid now, what about that nothing is refreshed and it
gets the first code, still?!...

Dan
may lie in the use of the single and double quotes in the
criteria. I have had this problem and it gave me the same
error message as you are getting. Below is what I think
it should be:
UserID is a variable. If you wanted to use a string as the
criteria you would need single quotes as below:
quotes, then a final double quote encloses the whole
criteria expression.
expressions, for more info study the DLookup Help file.

your

name