From: Alan on
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
From: Daryl S on
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.

--
Daryl S


"Alan" wrote:

> 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
 | 
Pages: 1
Prev: Apply changes to existing records
Next: da