Linking listbox to text box

[thefonz37]

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.

 

[Klatuu]

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.