Testing for Multiple Conditions?

J

Jim

Hello,
I have a bill of lading that uses a strshipvia field as a variable in a
Select Case statement to print the correct acct number on a report. Now I
need to test the strshipvia and strwarehouse fields together because the
acct number can change depending on the shipping location. I'm new to vba
and don't know how to test for more then one condition at a time. Any help
would be greatly appreciated.

Jim
 
S

strive4peace

try this:

'~~~~~~~~~~~~~~~~~~~

Select case TRUE

case rs!field1 = "something" AND rs!field2 = "other"
'statements

case rs!field1 = "something"
'statements

case else
'whatever didn't match up already

end select

'~~~~~~~~~~~~~~~~~~~

Warm Regards,
Crystal
Microsoft Access MVP 2006

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
 
Top