Case Statement in Access - Don't know the synax for Access

[teneesh]

I'm not very clear on the synax when creating a CASE statement in Access. Please take a look at this and guide me on the appropriate syntax please. Thanks

Private Sub txtCount_Exit(Cancel As Integer)
' Establishing perameters around counts for conferences
Select Case Me.cbxHosp

Case 1
Me.cbxHosp.Value = "Morning Reports" And Me.txtCount.Value > 20
MsgBox ("Morning Rounds <=20)

Case 2
Me.cbxHosp.Value = "Noon Conference" And Me.txtCount.Value > 20
MsgBox ("Noon Reports can be <=20")

Case 3
Me.cbxHosp.Value = "Grand Rounds" And Me.txtCount.Value > 5
MsgBox ("Grand rounds are <= 5")
End Select


End Sub

[MMcCarthy]

Try this ...

Private Sub txtCount_Exit(Cancel As Integer)
' Establishing perameters around counts for conferences
    Select Case Me.cbxHosp
 
      Case "Morning Reports"
      If Me.txtCount.Value > 20 Then MsgBox "Morning Rounds <=20"
 
      Case "Noon Conference"
      If Me.txtCount.Value > 20 Then MsgBox "Noon Reports can be <=20"
 
      Case "Grand Rounds"
      If Me.txtCount.Value > 5 Then MsgBox "Grand rounds are <= 5"
   End Select
 
End Sub
 

Mary