I have a form (frmSub) which is used as a subform on another form (frmMain). Based on the record show in frmMain, sometimes there is data in frmSub, sometimes there isn't.
The user has requested that the header of the subform has a red background if there is any data displayed. The subform lists exceptions and they want attention drawn to it if there are any exceptions.
I'm not sure how to accomplish this. How can I tell if any actual data is displayed or if the contents of the form are blank?