Testing for an empty recordsource

[PeteG]

Hi, I have a form that is bound to a recordsource - a table. I want to be able to test whether any data will be displayed on the form so that I can make it do something different, ie if there is no data in the table then I'll make all the controls invisible except for a label saying 'no data' or something like that.

So, I want to put a test in the 'on open' event to do this. I know that I could open a recordset on the same source as the form to find the row count or run sql to get the same...but is there an even simpler way of just testing the recordsource to see if it is empty?

Thanks for any help.

 

[randy700]

How about a dlookup? Something like...

If IsNull(Dlookup("KeyField","TableName")) Then

Randy

 

[dhookom]

You can check the number of records with code like:

Private Sub Form_Load()
    If Me.RecordsetClone.RecordCount = 0 Then
        MsgBox "No records"
    End If
End Sub

Duane
Hook'D on Access
MS Access MVP

 

[PeteG]

Thanks to you both, just what I was looking for.