I want my subform to stay "locked" to my main form.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't want to be able to scroll through subform records independent of
scrolling through main form records.

The reason that I desire this is to help me avoid orphan records and/or main
form data with incorrect subform data.

Or perhaps this is just a bandaid to my problem. For some reason, I am
being allowed to enter data from my main form without adding data from my
subform, and vice versa, even though they are supposedly linked.

Some help please!!
 
andreainpanama said:
I don't want to be able to scroll through subform records independent
of scrolling through main form records.

The reason that I desire this is to help me avoid orphan records
and/or main form data with incorrect subform data.

Or perhaps this is just a bandaid to my problem. For some reason, I
am being allowed to enter data from my main form without adding data
from my subform, and vice versa, even though they are supposedly
linked.

Some help please!!
Click to expand...

The MasterLink and ChildLink properties are what synchronize the subform records
to the related record shown in the parent form.

Proper relationships would prevent you from entering a child record without
entering a parent, but there is nothing that prevents you from entering a parent
that has no children as that does not violate the relationship. In fact when
entering both, the parent record is saved as soon as focus moves to the subform
so if such a rule were possible to set up the form would be unusable.
 
Back
Top