On opening a Form with SubForms records get changed

[RBB]

When I open a Form that has some subforms; some of the
records get changed; when the form is opened. Let me
explain: I have a MainForm and it has a subform called
SubFormA. I also have a another SubForm called SubFormB
that has it own subform call SubSubFormB.

MainForm based
------SubFormA
------SubFormB
----------SubSubFormB

SubSubformB display the person name. When the MainForm is
opened, it incorrectly takes the person name value from
SubSubFormB and changes a record the query that SubForm A
isbased. Hope this is enough info, if not I will supply
more.
Rbb

 

[John Vinson]

When I open a Form that has some subforms; some of the
records get changed; when the form is opened. Let me
explain: I have a MainForm and it has a subform called
SubFormA. I also have a another SubForm called SubFormB
that has it own subform call SubSubFormB.

MainForm based
------SubFormA
------SubFormB
----------SubSubFormB

SubSubformB display the person name. When the MainForm is
opened, it incorrectly takes the person name value from
SubSubFormB and changes a record the query that SubForm A
isbased. Hope this is enough info, if not I will supply
more.

I VERY much doubt that any records are actually being overwritten in
the Table, unless you have put some VBA code in the Form's Open event
to do so. It's much more likely that the subform linkage is bringing
up unexpected data.

What are the Recordsource properties of the four forms? What are the
Master Link Field and Child Link Field properties of the subform
controls?