Combo Box Problem

[edwired]

Hi experts..I have a small problem but i could not find the solution. I've created a form with combo box named "module" which allows user to make selection. This form allows user to make changes to the table which also has a delete button.

My problem is that when i press the delete button after choosing any record from the combo box, a message saying "the changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again" appear. But I can delete the first record.

Form my understanding, the message appear because it thought that i'm entering the same data. How can i delete my desire record in the combo box?

~Desperate Eddy~

[MMcCarthy]

Hi experts..I have a small problem but i could not find the solution. I've created a form with combo box named "module"

first thing is change the name to cboModule. Module has other meanings in access.

In design view go to the combo box and open the properties window.

Under the data tab in the control source there must be a field value. This means the combo box is bound to that field and is trying to save to it.

If that's not what you want delete it and leave it blank.

[edwired]

Yes sir, my combo box is actually bound from a table and i do it on purpose. But i wanted to delete the data in the table from a form. And the form has a combo box where i keep the data so that user can choose the from the combo box and delete. But when i choose a different record other then the first one, the system thought i'm duplicating the record. To be informed that my table only consist of one field which is also the primary key.