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?!...
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
expressions, for more info study the DLookup Help file.