Tab Control (1 Viewer)

[jrmellis]

I have a subform with Tab controls on it. A combo box which is used to select a site is on the master form. There are times when a site is selected and there are no relevant data on an associated tab. How can I check if the tab is empty and perhaps display a message or make a message label visible istead of the blank fields.

Thanks

 

[llkhoutx]

Check the record count in the recordsource for your subform. If 0, then display your message and do whatever.