Select case statement questions

[Alan]

in a Select case statement can i have two statement under one case for example

i got

Select Case Me.lstSalesPeriod
Case ByYear
strReportName = "Yearly Sales Report"
lOrderCount = DCountWrapper("*", "Sales Analysis", "[Year]=" &
Me.cbYear)

but i also want this case to do this

strReportName = "Yearly Sales Report"
lOrderCount1 = DCountWrapper("*", "1a11f raw", "[Year]=" & Me.cbYear)

can this be done

 

[Daryl S]

Alan -

Yes, you can have multiple statement for each case. All statements before
the next Case or End Select will be processed for the case.