records

[Thedon123]

how do i check if there is atleast one record in the table in VB

 

[ColinEssex]

You could use DCount

Col

 

[DJN]

If DCount("*", "tblYourTableName") < 1 Then
MsgBox "No Data in this table"
Exit Sub
End If

David