Switch statement?

[chuq2001]

I want to use a switch statement, but don't know correct syntax.

Like this

Switch(var)
    case  "NF"
         xxx=xxx
    case  "MW"
         xxx=xxx

I just need correct syntax

Chuck

 

[Quehay]

Hint: ALT F11 > F1 > Contents > Language Reference > Functions

Here's the example found there (just wrap a field name in []'s to be sure it understands:

Switch(CityName = "London", "English", CityName _
= "Rome", "Italian", CityName = "Paris", "French&quot
Jeff Roberts
Analysis, Design, & Implementation
RenaissanceData.com

 

[MikeDNova]

think this might be what you want....

Select Case Me![DataType]
Case "List"
Me.rptPrintComments.Report.Visible = True
Me.rptPrintCost.Report.Visible = False
Case "Cost"
Me.rptPrintComments.Report.Visible = False
Me.rptPrintCost.Report.Visible = True
End Select

this is just an example from some code i was using.
i know they call it switch in java. i think its called a select in VB

-mike