If Table is Empty....

[AT76]

Hi,

I'm trying to check if a table is empty in my access app.

Here's what I have:

If "TableName = 0 Then
MsgBox "No Parts where found."
GoTo theend
Else
End If

I'm having trouble with the correct syntax to look for the table ("TableName").

I would appreciate any help!

Thank you!

 

[PHV]

Provided the table is local (ie not linked):
If CurrentDb.TableDefs("Table1").RecordCount = 0 Then

Otherwise you may consider a domain aggregate function like DCount or DLookUp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AT76]

Thank you PHV