469,943 Members | 2,576 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,943 developers. It's quick & easy.

Combo Box Problem

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~
Oct 31 '06 #1
2 1742
MMcCarthy
14,534 Expert Mod 8TB
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.
Oct 31 '06 #2
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.
Oct 31 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Heather | last post: by
1 post views Thread by Jeff Smith | last post: by
7 posts views Thread by Ausclad | last post: by
4 posts views Thread by Dave | last post: by
2 posts views Thread by biganthony via AccessMonster.com | last post: by
rhitam30111985
3 posts views Thread by rhitam30111985 | last post: by
6 posts views Thread by =?Utf-8?B?amVmZmVyeQ==?= | last post: by
3 posts views Thread by evenlater | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.