Unbound Combo Box Query Parameter

[brezja]

I am putting the finishing touches on a database and I'm running into one last issue. I have a main table, a query for that table, an input form...and a search form that when run, populates the query based on any combination of values from unbound text boxes or unbound check boxes, mainly using the Like "*" & [Forms]![SearchForm]![Field] & "*" Or Is Null expression.



I do have a few unbound combo boxes in that form, as there are a few fields where I wanted to limit the input choices that I would like to be able to search with. My issue is that I am trying to come up with a Parameter Criteria, akin to the one above, to be able to bring up the value that I would choose in the combo box...but to overlook it if the field is left blank. Any ideas?

What happens is...if I use the Like "*" & [Forms]![SearchForm]![Field] & "*" Or Is Null it brings up everything and doesn't filter down to just someone in say...team 1. If I use the [Forms]![SearchForm]!Field it brings up no records except for the one that I search for...and some fields have null values because not everyone is on one of those teams. Should I cut my losses and just use an unbound text box instead?

[June7]

The LIKE and wildcard parameter should work with combobox reference.

But why do you show Field in your example? This should be name of control.

[brezja]

I just did it for the sake of example.......the real string reads:

Like "*" & [Forms]![frmSearchAllCampus]![sERT_Team] & "*" Or Is Null

[June7]

Don't know why not working for you, combobox works for me.

What is the value of the field this parameter is applied to? Do you have lookup set in table for this field?

If you want to provide db for analysis, follow instructions at bottom of my post.