I have a form based on “ParentTable” with a subform “StudentTable” (linked by a field [ParentID]).
Is there a way, when the form is opened, to limit the records that load from the “ParentTable” to those records where the linked records from the “StudentTable” have a field [Active] that is True?
(The ParentTable contains about 280 records, but for this time period, there are only 65 of those records whose child(ren) are “Active” for this particular activity. Ideally, I would like to have the form load by default only for those active families, but with the option to reload the form showing all 280 when I need to see them all.)
Does that make sense?