Exit Select Case - VBA MsAccess

Question

I need to exit the select case in vba ms access but I cant figure how to do it, this is a screen shot of the error I get.

enter image description here

what's stopping you typing text? – Mitch Wheat Dec 07 '13 at 09:26 — Mitch Wheat, Dec 07 '13 at 09:26

score 2 · Accepted Answer · answered Dec 07 '13 at 09:43

2

If this won't work...

Select Case Cat
    Case 1
        If (Condition1 Or Condition2 Or Condition3) Then
            Exit Select  ' <- Compile error
        End If

        ' do stuff

...then why not just do this instead?

Select Case Cat
    Case 1
        If Not (Condition1 Or Condition2 Or Condition3) Then

            ' do stuff

        End If

answered Dec 07 '13 at 09:43

Gord Thompson

116,920
32
215
418

This is what I did after all, thnx – Osama_Almaani Dec 07 '13 at 15:22

Exit Select Case - VBA MsAccess

1 Answers1