I have found this filtering technique very useful from time to time. Perhaps you will, too.

Example: Your listbox contains several hundred entries. You want to type in the first few letters of what you're looking for to narrow down your selection.

This example will show you how to use the OnChange event and build a SQL string dynamically to reassign the listbox rowsource.

There is both an ACC2007 and ACC2000 version attached.

Enjoy!