I have a feeling I'm missing the blindingly obvious, but here goes:
I have a form with a subform that work fine together, and are used for comparing imported records (in the subform) against existing data (in the main form). However, sometimes there are no data in the subform (ie no imported records matching an existing record), in which case I don't need to see the record in the main form at all.
In other words, I only want to see the existing records that might be affected by newly-imported data - only about 30% of the overall records.
Can I filter my main form to show only records that have one or more matches in the subform?