I have form on my database that runs a search query. Basically what should happen is the user types in what they want to search in a text box and the result is displayed in a list box.
This currently works but only if the spelling of the search is entered 100% accurately. e.g. if im searching for Access, no results would be displayed if i just typed in 'acc' but if i typed in 'access' it would display a result.
I would like it so they could possibley type in the 1st 3 letters and the results would appear.
The problem appears to be that it is searching the letters of the word from last to first, rather than first to last.
My query criteria is:- Like "*" & [Forms]![frm_clientsearch]![search]
Thanks for any help.
This currently works but only if the spelling of the search is entered 100% accurately. e.g. if im searching for Access, no results would be displayed if i just typed in 'acc' but if i typed in 'access' it would display a result.
I would like it so they could possibley type in the 1st 3 letters and the results would appear.
The problem appears to be that it is searching the letters of the word from last to first, rather than first to last.
My query criteria is:- Like "*" & [Forms]![frm_clientsearch]![search]
Thanks for any help.
