Help With Select Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Try this

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

maus
 
Back
Top