filters

[sd]

When I filter on a screen with a subfrom it does not display the subform
contents, is there a way to make it display subform information also. Also
it does not let you filter on the subform, is there a way to filter on the
subfrom?

 

[Rick Brandt]

When I filter on a screen with a subfrom it does not display the subform
contents, is there a way to make it display subform information also. Also
it does not let you filter on the subform, is there a way to filter on the
subfrom?

Applying a filter to the main form does nothing that would affect the behavior
of the subform. As long as the record displayed in the main form has matching
entries in the subform they should be displayed.

You can apply a filter to the subform as long as you put focus in the subform
before invoking the filter. However; if what you want is to filter the *Main*
form based on entries in the subform, that is possible but not with the standard
filtering tools. You essentially need a filter with a sub-select query in it
like...

IDNum In(SELECT IDNum FROM Sub-Table WHERE SomeCriteria...)