Hi,

Any help is greatly appreciated. I'm trying to create combo box that looks up employee records and displays the record based on the user's selection from a different combo box.

For instance, I have an employee table with 3 columns: Last name, SSN, and Employee ID. I want to create a form with 2 combo boxes adjacent to each other. The first combo box allows the user to select the criteria by which they want to lookup records. In this combo box I would create a value list with Last Name, SSN, and Employee ID. If the user selects SSN, the second combo box lists all SSN's in the employee table and retrieves the record for the SSN selected. Alternatively, if the user selects Last Name in the first combobox, the second would list all Last Names in the employee table and retrieve the record for the Last Name selected. Make sense? I was thinking I could create three different combo boxes and set their visible property based on the selection from the first combo box, but I'd really like to accomplish this programmatically with just the two combo boxes.

Thanks!

You can only select one field from a combo box you wouldn't be able to select either ID or SSN. Look up the solutions database for examples of filtering combo boxes.
Or use an option group to filter the second combo
HTH

[This message has been edited by Rich (edited 11-10-2001).]