Find as you type

Find as you type - utility (actually a module, which you copy to your MDB and “attach” to your forms) finds matching records with each keystroke you type by Allen Browne, Access MVP. I am also using similar approach in my applications, but with 2 differences:

• I look through all fields, so whatever user types - phone, city, email - he finds something
• I use timer event to start search, and search runs after user finished typing a string. on form open timer interval is set to 0, in change event I set it to 500, so once user did not press a key within .5 sec - form get filtered.

I mostly use it for applications with SQL Server linked tables, and perhaps Allen approach is best for Jet databases, will certainly try it in some application. Well done, Allen!