Unanswered: [RESOLVED] Code to check query for data or null
I have a form named “current”, I also have a query that is named “month” I need code that will check the query ( “month”) and if it contains data, activate a message box that will say, “There is activity in the month files”. I need this code to be called when the form first opens up.
Will a dlookup type code work?
If IsNull(DLookup("anyfield", "month", "")) = False then
msgbox "There is activity in the month files: