How do I create a "Type to Query" form in Access?
Posted on 2011-02-11
I have a database with a large number of contacts. I would like to create a form where I could easily narrow down my results by typing.
My form has 2 text fields. fld_fname and fld_lname. There is a list box showing all my contacts.
I would like to narrow down the list by typing criteria in the fields. Putting an A in fld_fname and T in fld_lname would narrow down the list to only show contacts with the initials A T etc...
Oh yeah, I'm using Access 2003.