In my combo box I have several names. When I select a new name, I should get a new record. This is so simple; I just can't put my hands on it.
I have attached the db. Please tell me what I am doing wrong.
I assume you mean the combo named "Employee"? There's no code behind it. Why would it create a new record? As is, it should populate the Employee field in the displayed record.