Have you tried to place second subform on the first subform and possibly get rid of the main form?
Igor
>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
Igor Gelin
Database Developer