Access 2007 Wildcard query in an unbound text box

[wm138]

Hello,



I am new to Access 2007. I have a list of companies of are constantly updated,deleted, and created which are listed on a table. I have a form with an unbound text box with a sumbit button that opens a new form with the information of the name of the company in the search box. Unfornately, if the name of the company is not perfect, the record is not found and the form opens a new record. I want search box tyo autill, or "wildcard" when I begin to input a name of a company. I tried a combo box but my boss does not like it. He wants a wildcard search. Any help would be greatly appreciated.

[June7]

What's so bad about combobox with AutoExpand?

You can set query parameter criteria with wildcard. Here is demo http://datapigtechnologies.com/flash...tomfilter.html

Other methods involve more code to set form Filter and FilterOn or RecordSource properties.

However, no method can guarantee successful search if entry in the criteria or the data are misspelled. E.g. search 'Wilsson' will not find 'Wilson' and vice versa.