Run time Error 3075

[Tuer]

Hi Experts,

I am trying to makes this Dlookup work, but I keep getting the message:

Run time errpr '3075' - syntax error (missing operatar in query expression.

TOP50_Navn = DLookup("[TOP50_Navn]", "InternKundeMap pingFil", "Customer_Numbe r=" & Customer_Number )

any suggestions??

thanks,
TUer

[Megalog]

I'm guessing "Customer_Numbe r" might actually be a string value? Try:

TOP50_Navn = DLookup("[TOP50_Navn]", "InternKundeMappingFil", "[Customer_Number] = '" & Customer_Number & "'")

Or maybe your variables arent declared correctly, and you need something like this:

TOP50_Navn = DLookup("[TOP50_Navn]", "InternKundeMappingFil", "Customer_Number=" & clng(Customer_Number))