Parameter Problem

I would like to pull up a query only by a certain client. I have two tables. When I enter [Enter Client Name] in the criteria the box pops up and I enter the client name but it doesn't work. When I put in the clentID number then it pulls up with the client name. I want to be able to put in the clients name and the clients profile comes up, instead of putting the clients ID number and the client name pops up. I know this sounds confusing but if anyone could help me I would be very grateful. Thanks!

I don't know if you will be able to look at the access table but i have attached it. It is the testwizard file in the query section.

what's SQL statement are you using? You might want to use a "like" statement so that it will pull up the client name.