Check to see if table has data in it

[jaybird19]

How can I check to see if a table has data? Based on whether or not tbl_Codes has any data in it, I want to run one of two macros. I need a boolean or similar function to let me know if tbl_Codes has data in it or not. I know how to set the macro after that.

Thanks for your help!

 

[jrbarnett]

If DCount ("*", "tbl_Codes") > 0 Then
  Msgbox "Table has data"
Else
  Msgbox "Table doesn't have data"
End If