Hello,
I am building my first database and need some help. I have a form set up with an Unbound Text Box that I use as a search box. When I need to search for a name, I simply type the name in the text box, click submit, and the record of the company name appears in the next form, Company information and all. Unfortunately, when a company name is mispelled, the next record will appear blank.
I would like to set up my text box to autofill or auto complete or give suggestions as the user is typing the company name. For example, if a user types "a", the company names that begin with the letter "a' will appear. The user now can choose from the list provided in order to prevent error. I am currently using Access 2007. Any suggestions would be greatly appreciated.
Thanks you.