This has probably been answered before somewhere, but I am trying to add a method of searching to my form that uses filters. The form sources all it's information from one query. Ideally the user should be able to, for example, enter a name into a text box and then the on_change event applies a filter showing only the records where the name in the name field of te query matches. If there are then 50 people with the name of "Jones" they might then have a combo box allowing them to select either Male or Female, narrowing the number of results down further. I don't want the results to be listed separately, just for the number displayed in the form to be filtered. Any ideas?
