Hi All,

If i could get some help with this please.
I have a continuous form listing product descriptions, on the header of my form i have placed an unbound textbox call txtsearch.
i wish to be able to enter a search string in the txtsearch and filter my records in the Continuous form accordingly.
Now the prod description contains info such as style, colour, name etc, when the user searches they may want to enter in the txtsearch info such as "red sofa baltimore" so i want the filter return to include all/any of the search criteria.
Eg that search should return "Red Chair" - "Blue Sofa" - "Baltimore Red Sofa Chair" in the continuous form.
I can get it filtering useing the like command but for some reason it will only return an exact match?
Can this be done?
Any help would be great

Thanks
Darren

There is a reason it is only working with an exact match. If you look at the text string, you will see this:

SELECT * FROM MyTable WHERE [FieldValue] Like '*red sofa baltimore*'

Which means, give me every record where the phrase "red sofa baltimore" is anywhere in the FieldValue field.

This is a problem with design, first of all, that you would have all this information in the product description field, so you are going to have to split the string into an array and then rebuild the criteria from the array.

Dim MyArray As Variant
Dim i As Integer
Dim sString As String

sString = Me.txtUnboundTextBox

i = 0
MyArray = Split(sString, " ") 'That is a space bar between the double quotes

sString = "[ProductDescription] Like '*" 'reset

Do Until i = Ubound(MyArray) + 1
sString = sString & MyArray(i) & "*' Or [ProductDescription] Like '*"
i = i + 1
Loop

'Remove Excess - removes Or [ProductDescription] Like '* from the end of the string
sString = Left(sString, Len(sString - 32))

Then pass sString to your query. You may have to play with is a bit, but you get the idea.



mmcdonal

Thank You

As usual your suggestion has taught me a bit more!

You are now at the top of my xmas card list!!!

Cheers