Combo box on main form to filter subform 1

[chadrj]

I am trying to set up a database to allow for data entry. I want the user to select the "object" from the combo box on the main form, and tab down to the subform and enter "attributes" on the subform. Currently when I select an object from the combo box then tab down to the subform, I get the following error:

"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. (Error 3022)"

I do not want the user to change anything on the object, or create new objects, but I am afraid that is what it is trying to do. How do I get the main form to act simply as a filter to allow for entry of attributes on the subform?

btw objects to attributes is a many-to-many relationship with the appropriate linking table "object-attributes"

Thanks

 

[beetee]

Try making your main form unbound (i.e. no record source), and specify a SQL statement that is equivalent to the main form's record source as your combo box's row source (except that you will want to specify only the appropriate field(s) for your combo box.