Open form only if subform has data

  • Thread starter Thread starter Cathy
  • Start date Start date
C

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
 
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
 
Back
Top