Change BackgroundColor of Header If Form Contains Data
Posted on 2013-12-02
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?