Filtering records in a subform while the user enters text (1 Viewer)

[JC10001]

Here is what I'm trying to do....

I have a form. The form contains a subform with records in it. For the sake of argument lets assume the records consist of first and last names. The form also has a text box for the last name field and a text box for the first name field.

I want to make it so that when the user types "A" in the last name text box only those records with last name starting with "A" appear in the subform. Then when the user types "n" (so the whole string is now "An") it will filter it again so that only records that have last names starting with "An" are displayed. It will refilter everytime a letter is typed or removed.

I'm wondering if there is an easier/faster way to do it other than telling the subform to requery every time someone enters a letter into the text box.

Any ideas?

 

[Lightwave]

On change filtering

JC10001

This is an example database containing the code that does this...

Link

Ie re-query using the "on change" property.