Just checking if true (Access2003)

Topic

New Reply

Quick question.
Does using this code means if Forms!RetReports!cmbLB IS NULL – show me everything???

If Not IsNull(Forms!RetReports!cmbLB) Then
strWhere = “BusinessName =” & Chr(34) & Forms!RetReports!cmbLB.Column(0) & Chr(34) & _
” And [Region]=” & Chr(34) & Forms!RetReports!cmbRegion.Column(0) & Chr(34)

End If

Thanks

Reply | Quote

Replies

It depends on how strWhere is used, but the answer is most probably “yes”.

Reply | Quote

This code is placed on Click event of the button that running the Report.

I am questioning only because when I have not selected any values – 200 pages Report comes up and shaking all up.
I can click on scroll bar and it will stop – than if I need to go to the next page – it is shaking up again. So I can never see IF this Report ran correctly.
Odd but happens all the time when I ran large Reports.

Thanks so much.

Reply | Quote

If you’d rather avoid opening the report without any restriction on the records, you can use

If IsNull(Forms!RetReports!cmbLB) Then
MsgBox “Please select something in the Business Name combo box.”, vbExclamation
Exit Sub
Else
strWhere = “BusinessName =” & Chr(34) & Forms!RetReports!cmbLB.Column(0) & Chr(34) & _
” And [Region]=” & Chr(34) & Forms!RetReports!cmbRegion.Column(0) & Chr(34)
End If

Reply | Quote

NO, requirement I need to let them have no selection.
But thanks for the idea, I am sure I can use it in future development.

Reply | Quote