Query not using Search Criteria

[FriQenstein]

Greetings all,

I'm having some issues with a couple of my Queries.
Here is the info:
User clicks on button to search the Misc. Inventory, so button calls Misc_Inv_SearchQ and then throws the results from the Query to a Report form.
However, when you type in the description to search for in the form, the Query doesn't seems to give a rats ass. It either never shows anything on the Report page, or it will show EVERYTHING in the Misc category.

Here are my Query search criteria strings:

Like '*' & [Forms]![Misc_SearchF]![DescriptionBox] & '*'
Like '*' & [Forms]![Misc_SearchF]![DescriptionBox] & '*'
Like '*' & [Forms]![Misc_SearchF]![PartNumberBox] & '*'

I've tried putting these 3 strings in the Criteria section with no reference to the Model field (The Model field in this case will be Misc)
I've also tried putting these 3 strings not only in the Criteria fields, but also in the OR: fields to see if that would help the search in determining between each of them... still no joy.



If I add ="Misc" in the Model field, then it will list every single item in table that has the Model field. (BTW: I have numerous fields for Model which I use to differentiate between the types of equipment in the entire Table)

So, for some reason, my queries don't seem to care about my actual search criteria. I'm wondering why.

Any advice would be greatly appreciated.
Regards.

[FriQenstein]

Update:
Ok, so I've removed 2 of the 3 search criteria strings, leaving only the Description search criteria.
This seems to work. However, if/when I add in the Serial number &/or the Part number search criteria, I get nothing but a blank Report.

I'm not certain what is causing this. Access if flaky like this. Every so often, things just break for no reason. It will work fine, and then all of a sudden a query doesn't run, or a report will be all fubar. I don't know why this happens, especially since nobody is editing the database, so there should be no reason for these type of intermittent glitches.

I have other Queries with multiple criteria options and they all seem to work perfectly fine. Every so often, I have to just nuke a query and re-do it from scratch and it will work for some strange reason... however, I refuse to be beholden to this type of glitch so I'm determined to find out why this happens and put a stop to it.

[Homegrownandy]

Is it possible you could upload a sample database with sensative data removed?

[Minty]

Can you put up a picture of the query in the query editor, I'm really struggling to understand your description I'm afraid.