After making some small chages to my search code I have found that my search is now returning incorrect results.
What is suppposed to happen is that when I search for a value in the volume field the search is supposed to return all results that match the full or partial search term (using "like" criteria in my query)
What is actually happening is that the search is only matching exact search criteria.
Any partial search requests result in the msgbox stating no matching results found.
This is the code that is found in the query for the volume field:
The above code is actually present on about 4 diff lines in the query tab.
Please Login or Register to view this content.
I could post a screenshot later if reqd.