Edit my detail by using combo box...

[alexkong2003]

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!!!!

 

[CEH]

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.

 

[alexkong2003]

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

 

[browny]

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