Good morning, I am attempting to see if a temp table is empty before the end user proceeds forward. I am at a loss as how to start. I tried if isnull and looked into isempty. What I am looking for is something like this:
IIF isnull ("tblImport_LMC_Child") then
Call MsgBox("The child datapoint has not been imported. Please import and try again.")
End IF
also tried:
Dim ImportChild As String
ImportChild = [tblImport_LMC_Child]
If (IsEmpty(ImportChild)) Then
Call MsgBox("The child datapoint has not been imported. Please import and try again.")
End If
I am novice and am looking for some insight.
Thank you