If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking listbox to text box
My set-up is this: I have two tables, one with Employee Name, ID, Date of
Hire, etc., and another table with Employee Logins and Employee IDs. These two tables are related through the Employee ID field and there are cases where an employee has multiple logins, so the relationship is one-to-many between the tables. I've designed a form from the Employee Information table with a subform for the login data embedded. What I would like to do know is create a listbox (or a combobox, I suppose) where you can click on the name and the employee information will populate into the form for editing. Any ideas on how to do this? I had been looking up cascading combo boxs, but I'm not sure this is the right way to accomplish what I want to do. |
#2
|
|||
|
|||
Linking listbox to text box
You don't need cascading combos for this. You need one unbound combo to use
to search for a specific record. You can use the combo box wizard to create a combo box that will do that for you. -- Dave Hargis, Microsoft Access MVP "thefonz37" wrote: My set-up is this: I have two tables, one with Employee Name, ID, Date of Hire, etc., and another table with Employee Logins and Employee IDs. These two tables are related through the Employee ID field and there are cases where an employee has multiple logins, so the relationship is one-to-many between the tables. I've designed a form from the Employee Information table with a subform for the login data embedded. What I would like to do know is create a listbox (or a combobox, I suppose) where you can click on the name and the employee information will populate into the form for editing. Any ideas on how to do this? I had been looking up cascading combo boxs, but I'm not sure this is the right way to accomplish what I want to do. |
Thread Tools | |
Display Modes | |
|
|