Hi everyone,

I am trying to bind one recordset into the main form and a sub form inside this main form. The below code does that in the Load event on sub form:

Me.Recordset = Forms!MainForm.Recordset

It is working fine except for the fact that when I try to modify any cell in sub form, the system produces an error saying "Update or CancelUpdate without AddNew or Edit".

If I don't use the above line and instead have its own Recordset in both then there is no problem. However, I do not have the link between the main form and sub form.

FYI main form does not have any control in it. I need the main form to have this recordset same as sub form because I have another sub form inside this main form and that has linkmasterfield, linkchidfield relations.

Thanks for any help
Regards