Ok, maybe I'm an idiot. It was working fine. I have a table called employees and it lists all employees. I have a table called safety that I want to enter info for specific employees. Safety form needs employee info. On safety form, for last name, combo box looking up values in employees table. So far, so good. First name is a text box whose control source is =[LastName].[column](1). First of all, the employees first name is not being put in the safety table. SEcond, if there are two employees with the same last name, then the first employees name is entered regardless of who you click on.

I have tried to follow the example given by both the Solutions and NOrthwinds databases. I'm obviously not an advanced enough user to completely understand or make this work. Please HELP!