How do I get empty cells to populate in unbound form search

[KatieKitt]

I am using an unbound search form to search a query in Access and I'm having trouble getting the filter results to include cells that contain no data.

My form is set up with "Client Name", "Contract Name", "City", "State", "Start Date", "Termination Date" and "Member Lives"

So, say I do a search of a partial client name "American", right now, it only brings up terminated clients which have a date in the termination field. That cell is blank on active clients. I need my query to include those blank values in addition to the terminated contracts if the field in the search form is left blank.

Right now, in the design view of the query I have the following command in each column (with the appropriate header for each):

Like "*" & [Forms]![Data Search]![Contract Name] & "*"

How can I edit this command to also include empty cells?

 

[AccessBlaster]

have you tried it like this?

Like [Forms]![Data Search]![Contract Name] & "*"

 

[KatieKitt]

have you tried it like this?

Like [Forms]![Data Search]![Contract Name] & "*"

I tried this and no luck.

 

[arnelgp]

Right now, in the design view of the query I have the following command in each column (with the appropriate header for each):

i think the criteria in [Contact Name] will suffice. no need criteria on the other columns.

 

[AccessBlaster]

You could have multiple criteria, you just need to put it one row down. See attached.