I have a table, (Involved Persons) for which I would like the user to be able to query from most of the fields, (Last_Name, First_Name, Date_of_Birth, etc.) I would like to have a screen where they can type in what they know, and a subform showing possible matches. i.e., the more data you put into the search, the better the result. I have played around with Combo boxes, and that seems to be the way to go. But... I would like the entries in the combo-boxes to be additive. i.e., Last Name (Smith) pulls up all the Smiths. Then one enters First Name (John) the possibilites narrow to John Smiths etc. I would like this to work like the filter you get from a right click.

Any suggestions would, as always, be appreciated.

Peter Paul

[This message has been edited by Peter Paul (edited 03-30-2000).]

[This message has been edited by Peter Paul (edited 04-03-2000).]