I have several forms that are populated by queries. If the query returns no records, the form becomes a solid gray box. None of the controls or anything display.
I tried having a message box appear stating that there are no records to display, and then closing the form.
If IsNull(Me.Recordset) Then...
But, Access seems to skip over that, as if the record set is not empty.
Is there a way to have my form controls appear if there are no records to display, or what would be the correct code to use to get the form to close?