Searching and Paging with ASP and Access 2000

 

I have SearchForm.asp with the following

Drop down called TypeSearch which selects the field from the database
Text box called SearchBox which allows the user to type in what they are looking for

This is a POST with name = "SearchForm"

 

The on SearchResults.asp

I am wanting to display the matching records with paging. My Sql is built into an If Then Else statement:

If Request.Form("TypeSearch") = "txtYear" Then
   strYear = Request.Form("txtYear")
   Sql = "Select Title From Titles Where Titles.[Year Published] = " & strYear
Else
   ... alot more If statements like the one above for all of the other fields
Else
   'what would I put here to have it set equal to the value of the previous queryString which may or may not be a YEAR query
End If

 

I don't fully understand QueryString(whatever)

Thanks for all of your help!