Hello everyone.
I am building a small database that will hold information about volunteers and their talents. I have created a search form, in which the user can enter a keyword and it will search the tables for any match. Currently I am using a criteria of: Like "" & forms!SearchForm!Keywordtxt & "". It all works great... my only issue is that when I type "Ch" in the keyword box instead of just getting words that start with "Ch" like China, chair, chocolate and such i get any word that has CH... like Chair, computer tech, Techno....etc. How can I correct this so when I type "Ch" in the field the query will only give me results of the beginning of the word?
Any help in this matter will be greatly appreciated. I have not been able to find any answers on this. :(