Help With Select Statement

C

cvegas

I apparently am doing this select case statement incorrectly. Any help would
be appreciated.

Select Case AirportFrom
Case Me.AirportFrom = "ANC"
DoCmd.OpenForm "ANCRateSheet"
Case ""
MsgBox "Anchorage Not Selected"
End Select
 
O

Ofer

I assume that this what you are lookng for

Select Case Me.AirportFrom
Case "ANC"
DoCmd.OpenForm "ANCRateSheet"
Case ""
MsgBox "Anchorage Not Selected"
End Select
 
M

Maus

Try this

select case airportfrom
case = "ANC"
docmd.openform "ANCRateSheet"
case else
Msgbox "A not selected"
end select

maus
 
Top