Hi

For a table column that contains the text ' orange blue green '

If a user types 'orange blue' Autocomplete finds the column
If a user types 'blue green' Autocomplete finds the column
If a user types 'orange green' Autocomplete DOES NOT find the column

For the actual search when the user submits the form, I am using a SearchArray = Split(SearchField," ", for i = 0 to Ubound(SearchArray) ... method to generate a SQL statement that returns results that contain all keywords ANYWHERE in a table column.

Any ideas how to change the SQL for this, please?

Jason Burns
Touch Web

Edited by - Jason Burns on 25 Jun 2009  12:34:44