quick & easy one on Select Case syntax

[gussy]

Hopefully a quick and easy one....forgive the stupid question, but I don't have quick access to a reference book.

The 'Select Case' statement: I want to have a 'case is' for several cases with the same code, ie:

case is = "a" or "b" or "c" or "D"
lines of code
lines of code
lines of code


I can't get the syntax right for the 'or' bit ....(I'm assuming this can be done this way?)

Many thanks in anticipation.

 

[ghudson]

I just posted some code using the Select Case here...
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=57429

HTH

 

[gussy]

Actually, I think I've cracked it. I needed commas...


as in:

Case "a", "b","c"
line of code
line of code


etc.

Thanks anyway.