Hi,
I don't know if what I am doing is the best way of doing it but I'm not sure what else to do - either way I'm having combo box problems.
I have a form with a combo box that gives me a list of names from a table. WHen I select the name I want the rest of the form to bring in the rest of the employee details so I use the following script:
Private Sub Combo71_AfterUpdate()
[Form1]![EmployeeName] = [Form1]![Combo71].Column(1)
[Form1]![EmployeeNbr] = [Form1]![Combo71].Column(17)
and so on. It works perfectly but when I close and reopen the form, the employee name is repeated in the drop down and the table has been updated with the details again. I read about un-binding it so removed the row source and changed the name of the combo box so it wasn't the same as something in the table but now it just adds in a blank field to the table everytime I close it.
I'm only using this info to look up the details. They are stored in the table and will remain there - they don't need to be updated - it's just to look up contact details etc. Don't know if this is the best way or if there is another way. Everything is all on the one form - no subforms or anything.
Many thanks for any help! Been tearing my hair out for days with this