On opening a Form with SubForms records get changed

  • Thread starter Thread starter RBB
  • Start date Start date
R

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
 
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.
Click to expand...

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?
 
Back
Top