Edit my detail by using combo box...

Hi Everyone,

I have a problem here... i need help... could someone know that how to using a combo box to edit the details?

Now i am using the Employee Name as my primary key and i set it as a combo box to let user to select the name and list all the detail like IC, Job Position, Date of Employment and etc. But when i try to edit the detail of the employee, the access program do not allow!! And i know is because i am going to create a duplicate record by the employee name.

So, do someone know how to use the combo box to list out all the details and after i doing editing by pressing a 'Save' button then the detail just change without creating a deplicate record? Maybe someone just give me a little bit idea then is enough... Thank you!!!!

First, do not use "Employee Name" as a primary key. Use another field such as "EmployeeID" Perhaps an "auto number field. What if you have 2 "John Smiths" ? Get that done first, create your form from a query of the table or tables and see if things work differently.

Thanks CEH~~ I will try it and see it work or not... anyway thanks alot!!

Hi Alex
As suggested by RuralGuy on my thread, trialling the fixes suggested in the Access help files worked to solve the problem I was having. The form property "RecordsetType" needed to be set to Dynaset(Inconsistent Updates). Once this was done, selecting from the dropdowns worked perfectly, just as I wanted it to.
Regards Craig