Hello
Is there a way in VB to have a report NOT output if it's blank? I've tried using:
dlookup and writing a SQl statement in my code before docmd.output but nothing is working. I've been searching the internet but nothing I've tried lets me check to see if any records exsist in a table before moving on. What I was trying to do is
varX = Dlookup("[expr1]", "tbl_DEPOSIT_Output")
If varX = "" Then
'Do nothing
Else
Docmd.outputto acoutputreport.
Hopefully someone can help.
Thanks.
Is there a way in VB to have a report NOT output if it's blank? I've tried using:
dlookup and writing a SQl statement in my code before docmd.output but nothing is working. I've been searching the internet but nothing I've tried lets me check to see if any records exsist in a table before moving on. What I was trying to do is
varX = Dlookup("[expr1]", "tbl_DEPOSIT_Output")
If varX = "" Then
'Do nothing
Else
Docmd.outputto acoutputreport.
Hopefully someone can help.
Thanks.