With help from members of this forum I have a working search form that checks search criteria against the fields they are associated with. My next step to tackle is to include "keywords" that search for their own set of criteria. For example, I would like the user to be able to search for "Z1"...
I'm trying to set up a search form with 4 txtboxes for search criteria, each text value passed needs to be compaired 5 fields of my database. If I use only one field for the search everything works OK, but as soon as I add 'OR' to search multiple fields it will return ANY records with ANYTHING...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.