Syntax error on DLookup-function

H

haukalid

The following DLookup-function only returns a syntax error message in the
controlsource of a textbox in my report:
=DLookUp("[clientname]","[clientregister]","[clientID]=1")

In the immediate window in VB-code, the function gives the expected result,
but not in the controlsource.

What do I do wrong?
 
D

Duane Hookom

I would check the name of the text box to make sure it is not the name of a
field.
 
Top