Thank You Eric, I still need some help
When I used the datassist search wizard I selected the columns I would like to search correctly. I have been messing with it to sort it out properly but I am fairly new, it is most likely something I am missing.
First I have the recordset set to select the columns only is that correct?
Then I used the search wizard and I selected out of the column for the Itemname and Itemshortdescription to be chosen I highlighted the both here is what I have as a search parameter.
1. Type 2.Selector 3.Column 4. CT 5. Comparison 6. Value
1. Key 2. AND 3. Itemname, Itemshortdescription 4.T 5. Includes (although I had it previously set to begins with) 6. Post form (which works)
The problem is that when I search items I want it so that it will look up that item exactly that meets both criteria otherwise don't show other products that aren't related. Tell me what I can do to achieve this.
I appreciate all your help and products.