form-subform with all records

[Guest]

I have a main form with one list box. When i make a selection in the list box
the subform which is linked shows me corresponding records. The problem is
that i have added in the list box a selection "all" so that user can see all
the records of the subform. How should i link the forms?

 

[Rick Brandt]

I have a main form with one list box. When i make a selection in the
list box the subform which is linked shows me corresponding records.
The problem is that i have added in the list box a selection "all" so
that user can see all the records of the subform. How should i link
the forms?

You would pretty much have to execute code in the AfterUpdate event of the
ListBox to remove the MasterLink and ChildLink properties (set them to "") when
the "All" choice is selected. When any other choice is selected the same code
event would need to put the original values back into those properties.