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!
2 Comments:
Alex,
Could you post your code for this? It is exactly what I am looking for.
Brgds,
Maarten
I have a listbox filled with customers, based on a pass-through query, when user update textbox - i modify query's SQL and re-set listbox rowsource. thats all
Post a Comment
<< Home