I have re-written this stupid dlookup a million times and it always
says #Error and I am going crazy. Please help.

I have an Integer field called FileID that I am trying to lookup on
the Fax Center table from SharePoint (linked in Access). I want to
return the field "URL Path" from the Fax Center table.

Here is what I have

Dlookup("URL Path","Fax Center",ID = " & [FileID])

(The primary key on the SharePoint Fax Center Table is called "ID". I
can't change it.)

Please tell me what is wrong.

Thanks,
Laura

Never mind. I figured it out. I needed brackets around [URL Path].

I don't put spaces in my filed names so I'm not used to checking for
that.


On Mar 10, 10:31*am, musicloverlch <lho... (AT) gmail (DOT) com> wrote:

On Wed, 10 Mar 2010 08:31:15 -0800 (PST), musicloverlch wrote:

Field names that include spaces "must" be enclosed within brackets,
i.e. [URL Path] not URL Path.
Also you did not place a " before ID = "

= Dlookup("[URL Path]","[Fax Center]","[ID] = " & [FileID])

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail