Dlookup on multiple criteria (1 Viewer)

Pavczech · Aug 16, 2012

Hi guys
Could somebody help me to find the error in this syntax, please.

DLookup("[ID]", "Visitors Book - Personal", "[First Name] ='" & Forms![VisitorsBookIn]![First Name] & "'" AND "[Surname] ='" & Forms![VisitorsBookIn]![Surname] & "'" )

It should look for the "ID" of a user "First and Surname" in the "visitors Book - Personal" table

Thanks veru much

vbaInet · Aug 16, 2012

Here you go:

Code:

DLookup("ID", "[Visitors Book - Personal]", "[First Name] = '" & Forms![VisitorsBookIn]![First Name] & "'" AND Surname = '" & Forms![VisitorsBookIn]![Surname] & "'")

pr2-eugin · Aug 16, 2012

Would be helpful if you could tell us where exactly you are getting this error.. For starters..
* Enclose Visitors Book - Personal within [] as [Visitors Book - Personal].

Pavczech · Aug 16, 2012

Hmm not sure I can run:
?DLookup("ID", "[Visitors Book - Personal]", "[First Name] = '" & Forms![VisitorsBookIn]![First Name] & "'")
and
?DLookup("ID", "[Visitors Book - Personal]", "[Surname] = '" & Forms![VisitorsBookIn]![surname] & "'")
separeted but when putted together :
as you said:
?DLookup("ID", "[Visitors Book - Personal]", "[First Name] = '" & Forms![VisitorsBookIn]![First Name] & "'" AND Surname = '" & Forms![VisitorsBookIn]![Surname] & "'"
it comes out with

compile error:
expected: expression

Thanks

pr2-eugin · Aug 16, 2012

Try using this..

Code:

DLookup("[ID]", "[Visitors Book - Personal]", "[First Name] ='" & Forms![VisitorsBookIn]![First Name] & "' AND [Surname] ='" & Forms![VisitorsBookIn]![Surname] & "' ")

Pavczech · Aug 16, 2012

Brilliant
Thanks very much

pr2-eugin · Aug 16, 2012

You are welcome..

Dlookup on multiple criteria (1 Viewer)

Pavczech

Registered User.

vbaInet

AWF VIP

pr2-eugin

Super Moderator

Pavczech

Registered User.

pr2-eugin

Super Moderator

Pavczech

Registered User.

pr2-eugin

Super Moderator

Similar threads

Users who are viewing this thread