can't update form - recordset object...

[ymds]

when i try, i get a message that i can't update recordset object..



i didn't define nothing as recordset boject. why is it happen?
when i create a form with only one table fields i can update my form.
but when i add more fields from other tables i get that message and cannot update anything...

[jzwp11]

When you create a form, it is bound to a table or a query (that joins several tables). The table or query to which a form is bound is the recordset object.

This link has more details on what is causing the error. In order to avoid the error, it is best to have a form-subform set up with the form bound to the table of the one side of a one-to-many relationship and the subform bound to the table that makes up the many side of the relationship.

For example, let's say that you have a table of companies and each company can have many employees (one company to many employees relationship). You would create a form based on the companies table and then you would add a subform based on the table that holds the related employees.

In your case, you should separate some of the fields (controls) into a subform. Exactly which ones to separate depends on your table structure, so in order to help you further, we would need to see what your tables look like and how they are related.