search page help

Need help with search page using asp

[newbiehelp]

I am new to this forum and would like to seek some help with my coding.

I have a search page and the values searched are loc and title. I have a dept table which has these entries and when users search, they search the dept table for results. The titles in dept table are:

Receptionist
Customer Service Assistant
Front Desk Clerk
Data Entry Clerk
Computer Operator
Data Entry

when the users select loc as 'North Carolina' and title as 'Receptionist', I am trying to bring all the results related to 'Receptionist' such as :

Customer Service Assistant
Front Desk Clerk

and for 'Data Entry Clerk':

Computer Operator
Data Entry

etc.,etc.,

I am trying to use a Select Case to implement this search such as:

Select Case title
 Case "A"
  A = "Receptionist"
  A = "Front Desk Clerk"
  A = "Customer Service Assistant"
 Case "B"
  B = "Data Entry Clerk"
  B = "Data Entry"
  B = "Computer Operator"
End Select

And my code doesn't seem to work. Can someone please let me know whether my approach to the search is right, if not what would be the best way to implement this search? Thanks in advance for any help provided.

[newbiehelp]

Can someone please help me with this? I am kinda stuck and going no where with it.