How to tell if table is empty

[Guest]

I would like to find out if a table is empty. I've tried using the
recordclone event and it works. But I need to know if the table is empty
before I open the form (using the recordclone). Is there a function similar
to isempty for tables?

 

[Dirk Goldgar]

I would like to find out if a table is empty. I've tried using the
recordclone event and it works. But I need to know if the table is
empty before I open the form (using the recordclone). Is there a
function similar to isempty for tables?

Simplest is to do a DCount on the table:

If DCount("*", "YourTableName") = 0 Then
' the table is empty
End If

 

[Guest]

Thank you Dirk. I really appreciate the help.