DLookUP Help Needed

[Kirsti]

Hi, I am trying to get my DLookUp to work, and can't for the life of me.

Here's what I have (which isn't working):

strWebAddress = DLookup("[URL]", "Complex_Photos", "[Complex_BE] = Forms![OpeningForm]![Text37]" And "[Document_Purpose]", "Complex_Photos" = 'SiteAerialHO'")

It works until I put the And clause in, and then I'm getting a syntax error.

Any suggestions much appreciated.

Thanks,
Kirsti

[John_G]

Hi -

You have quote marks in the wrong place. I don't quite see the comparison you want to make following the AND, so I'm guessing, but try this

strWebAddress = DLookup("[URL]", "Complex_Photos", "[Complex_BE] = '" & Forms![OpeningForm]![Text37] & "' And [Document_Purpose] = 'SiteAerialHO'")

That assumes [Complex_BE] is text and encloses the value from the form in single quotes; if it is numeric, then try this:

strWebAddress = DLookup("[URL]", "Complex_Photos", "[Complex_BE] = " & Forms![OpeningForm]![Text37] & " And [Document_Purpose] = 'SiteAerialHO'")

John

[Kirsti]

Perfect - thanks John!!

Complex_BE is numeric, and your second example worked perfectly!

Thanks again,

Kirsti