Parameter Query on a LookUp table field

[oquinnc]

Table 1: Clients – has a particular field that has the client name.
Table 2: Client_Servicing – has field that looks up the client name on tblClients – works fine.

I am creating a Parameter Query so the user can enter the name of the client to see the records for that client in the "Client_Servicing" table. In the criteria field I have:

[Enter Client]

On other fields such as date (in the criteria I have [Enter Date]) it works fine. But with criteria on a field that is a lookup, I get the following message when the query is run:

"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."

How do I get the query to work?

 

[67peshawar294]

oquinnc,
Try using the Like operator to get the parameter query to work. In the criteria section type;
Like [Enter Client]
A "Enter Parameter Value" box will appear.
jp

 

[oquinnc]

When I use the "Like" operator as you suggested, I don't get the error, but there are no records found in the query.

 

[67peshawar294]

oquinnc,
If you type in the entire clientname exactly as it appears in the field of the client table it should... should give you results. Try the first few letters and an * as a wildcard and see if it doesn't produce results.
If not, is the relationship between the tables set up?
jp