Please see attached file to see what I'm trying to do. My question is this... When the user starts to enter, for example, an ID number in the ID field, the listbox will start to populate with records that have that ID record. Or, for example, when the user starts to enter a First Name in the FirstName field, the listbox will start to populate with records that contain that first name.
But imagine the user is typing "St" in the First Name field... then for example all of the "Stan" and "Steve" record will be displaying. But when they continue of typing and have typed "Ste" then only the "Steve" records will be displaying. Then the same thing is true for all the search text boxes... ID, First Name, Last Name, Address, and City.
Is this even possible?