If subform is blank, dont show main form..

[greenfalcon]

My title is a little confusing, i have a form with a subform, what I want it to do is this say i have 10 records, 3 of which are missing any data in the subform... then when i show the form it only shows 7 records. This way all records have data in both the main form and the subform... is this possible?

Thanks

 

[gemma-the-husky]

instead of basing the main form on the main table, base it on a query that excludes records with no matching data.

alternatively you could but an oncurrent event on the main form that hides the subform if there is no data, and displays a label on the main form saying NO DATA or something similar.