Query doesn't display any results

[premis]

I am trying to build a query for a client database that I can search a field for their client status (current client, in progress, etc) I built the query, but when I run it I don't get any records returned. I am using a form to enter the query criteria and then using the query to populate another form. I have done this with names, e-mails, etc and they work fine. I'm not sure why I am having trouble with this. Here is my query SQL

SELECT Clients.Status, Clients.Company, Clients.[Last Name], Clients.[First Name], Clients.[E-mail Address], Clients.[Business Phone], Clients.[Home Phone], Clients.[Mobile Phone], Clients.Notes
FROM Clients
WHERE (((Clients.Status) Like "*" & [Forms]![Client Search Form]![Status] & "*"));

In this case the form "client search form" has a box "status" that I am entering the criteria (ex: "In Progress"). I then have a macro button on that form with the following:

OpenQuery - SearchQueryStatus, Datasheet, Edit
OpenForm - SearchQueryClientStatus, Form, , , , Normal
Close - Query, SearchQueryStatus, Prompt

This is built the same way as my other queries, so I'm not sure why it isn't working. Any help would be appreciated.

[alansidman]

Is the status on your form a combo box that is linked to another table with the status' listed? If so, have you added this table to your query?

Alan

[premis]

Thanks for the reply, Alan.

The status on my form is now linked to the table with my status' (it wasn't before). But it is only pulling the ID column, not the 2nd column that lists the status'. Do you know how I can pull the correct column? As for adding the table to my query. The query only uses my clients table (with all the client information). It uses the status field in the client table to search for status using this formula

Like "*" & [Forms]![Client Search Form]![Status] & "*"

. The status field on the clients table sources the client status table.

I hope I'm explaining it correctly, I'm a bit of a newb for access.

[alansidman]

You need to add the second column showing the status to the QBE grid. For the ID, make sure that the display box on the QBE is unchecked so that you only see the status displayed.

[premis]

I got it!! Thank you so much Alan! I greatly appreciate the help!