Error when using a sub-form

minez50

New member
Local time
Yesterday, 16:41
Joined
Feb 12, 2006
Messages
8
I have created a subform where you select a vendor from a combo box and this then allows you to view all software of the selected vendor in a tabular view. When I use this form and then try to go into design view or close the form, i get the following error message:

'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 or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again'

I have tried removing the index and changing the index to permit duplicates but this has not worked.

Could anyone tell me abit more about this error and how to get rid of it?

Many Thanks
 
Here's a guess...... Do you have a field that is a primary key that you are trying to write information to?
 
The field vendor, is a primary key but i am not attempting to do anything with the key. All the i need to be able to do is choose a vendor from a combo box. Once that is chosen, my subform should display software that belongs to this vendor. Although i can do this, when closing the form or switching to design view i get the stated errors
 

Users who are viewing this thread

Back
Top Bottom