form filter for blank record

[Guest]

Hello,

I have a form with a subform. The subform gets information from a query.
All the query does is pull information from 2 tables into 1 query for the
subform. I don’t want the main form to show the record if there isn’t any
subform record. Would I use a filter in the query or do I use another filter
in the form itself such as, filter excluding selection? Any help is greatly
appreciated.

Thanks,

Yamareezy

 

[Allen Browne]

You want to exclude any record from the main form that has no match in the
subform?

Use a query as the RecordSource of the main form. This query will use the
subform's RecordSource query as an input "table", along with its own table.
Do not drag any of the subform's query's fields into the output grid, but
the inner join will suppress any main form records that have no match in the
subform's query.