By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,101 Members | 1,335 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,101 IT Pros & Developers. It's quick & easy.

Combo Box Problem

P: 2
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
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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

P: 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.