Open form only if subform has data

[Cathy]

I need to write a button click event that look at three
forms and only open the form/forms that have data in the
subform area. How do I go about checking the subform for
data or empty?

Thank you!
Cathy

 

[Gerald Stanley]

You can examine the recordcount of the subform's recordset.
If it is zero, you know that the subform has no data.

Hope This Helps
Gerald Stanley MCSD