grapisarda
11-09-2001, 11:37 PM
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!
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!