I tend to use combos to allow my users to find their required data via a "drop down".
This works find if there are not too many results in the drop down.
However, I would like to provide the users with a "string search" facility (if easy).
I have 10,000 names in a tblCustomers.CustomerName.
If I type "smith" then all customers containing the string "smith" will be displayed.
At present I achieve the above by allowing the users to Cntrl+F on a continuous form. However, this is not elegant.
Can anyone point me to a neater solution?