Posting Access 2002 Query results to Access page doesn't work

[Gromit73]

Hello,

I'm having trouble getting my Access Pages to work how I want them to in Access 2002. I have created a query that will allow my users to search a database by client name. I would like them to be able to search the data base by entering only part of the client name. That way they can enter "gro" rather then "gromit73" to find me in the list.

I have set up the query to do this. And I get the correct results. The query was created and then in the field that I wanted to filter by I added the line:

Like "*" & [Please Enter Client Name] & "*"

This produces a list on clients that contain the search string. but when I create a page that is based on this query I get no results (even though there are results in the "query table&quot. If I change the query to this:

[Please Enter Client Name]

Then I will receive results only if I type in exactly how the client was entered into the database. These results DO show up in the access page!!

Why does the second query criteria work for the access page but the first criteria listed doesn't??? Is there a way that I can get the criteria to work with the access page?

I hope you can help!

Thanks,
~