Dlookup help please. (1 Viewer)

[hully333]

I have produced a dlookup to grab the telephone number of a contact on a form and it returns the folloing error;

run time error '3075': syntax error (missing operator) in query expression ......

Heres the code;
lookup = DLookup("[contact_tele]", "[contacts]", "[contact_name] = " & user)

I cant see whats wrong with it and have cross checked the help on it.
It looks for the contact telephone number from the contacts table where the contact name is that from the variable called user, It then sets a text box on the form to the value of the lookup variable. The error quotes the actual contact when displaying the message box.

Any help would be great.

 

[namliam]

Because your contact_name is probably a text field you need to use quotes around the user name

Like so:
DLookup("[contact_tele]", "[contacts]", "[contact_name] = '" & user & "'")

 

[hully333]

Many thanks that solved the issue.

A little typo though, heres how it looks;
lookup = DLookup("[contact_tele]", "[contacts]", "[contact_name] = " & "'" & user & "'")

 

[DCrake]

Simple Software Solutions

As you have resloved your little problem and might not read this again, I aim this comment at other users. Don't use a variable name called user this may conflict with reserved words in Access.