Syntax error on DLookup-function

[Guest]

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?

 

[Guest]

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