Hello everyone,
This is the situation

I have a form that requires a user to input information. From the input a table will open and display data.

Since there are a lot of different choices (90+) would it be better and faster to use a SWITCH() rather than multiple IF statements?

this is an example of the code:

' test for locality and set table name

If request.form("tableName") = "LA" then
tablename = "LA_Codes"
End IF
 IF request.form("tableName") = "0082001" then
tablename = "North_Dakota"
END IF

I want to learn to do things the right way.
Thanks
dink

Since this all revolves around one FORM variable why not place the table name in the value that gets passed from the "tablename" value?

So then all you would ahve to do is:

tableName = Request.Form("tableName") and eliminate the need for convoluted code.

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========

Now why didn't I think of that... That is sooooooooooooooo much easier and makes a lot more sense...
I knew the IF's were not the right choice but I couldn't think what else to do.
Thanks gbianchi!!!!
dink