Information générale
Titre:
Binding one recordset to a main form and sub form
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement