problem with DLOOKUP function access 2003

Hi all,

I have such a problem I am trying to assing DLOOKUP function to textbox in report in access:

VB Code:

=DLookUp("nick";"users";"id_user=" & number)

where number is global variable defined as long

unfortunatelly it doesn't work it returns #error.

Please help.
regards,
sweet_dreams

Use commas as separators rather than semi-colons.

VB Code:

=DLookUp("nick","users","id_user=" & number)

hi DKenny,

when I try change semi-colons on commas I get the message saying that I should use semi-colons,

sweet_dreams

Can you post the entire procedure?

i have assign above manually code to textbox's control source property. textbox is on the report