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:
Code:
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.