Error Message for DLookUp

Hello All,

I have a query with the following fields:
Member Number
Member Name
State
Review Date

I have 2 tables:
Committee Report and
Delivery Tracking.

I have joined the 2 tables in the query by the unique member number. The
issue I am having is that I am trying to create a report based on the query
but cannot seem to get it to work. What I would like is for once the member
number is selected in the Delivery tracking database the Member
Name,State,and Review Date to be pulled from the Committee Report table. I
have tired using the following information by entering it into the criteria
section of the query but I get the following error message:

DLookUp("[Member #]", "[Committee Report]", "[Member Name] = " & [Member
Name])


The specified field [Member Name] could refer to more than one table listed
in the From clause of your SQL statement. Below is the

Yes, I do have a field called Member Name, State and Review Date in the
Delivery tracking Field because I thought it was needed in order for the
query to deliver the information back in the query. Can someone please advise
where I have gone wrong?

Thank you in advance.

One has to assume that [Member Name] is Text, and you have the syntax as if
itit were Numeric.


DLookUp("[Member #]", "[Committee Report]", "[Member Name] = '" & [Member
Name] & "'")

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200910/1

Sorry, that should be

DLookUp("[Member #]", "[Committee Report]", "[Member Name] = '" & [Member
Name] & "'")



Linq Adams wrote:
One has to assume that [Member Name] is Text, and you have the syntax as if
itit were Numeric.

DLookUp("[Member #]", "[Committee Report]", "[Member Name] = '" & [Member
Name] & "'")


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200910/1