Filtering by Multiple Fields
Written by Eric Smith, Northstar Computer Systems LLC
A user asked how to use the Filter property of the recordset to filter a recordset by more than one field. The answer is to build a more complex WHERE clause to put into the Filter property. Here's an example, assuming two boxes named Request("txtOne") and Request("txtTwo"):
rs.Filter = "Field1 = '" & Request("txtOne") _
& "' AND Field2 = '" & Request("txtTwo") & "'"
You have to concatenate the fields, but you have to put the right punctuation and keywords between the fields first.
Keywords: [
Active Data Objects
|
ASP Built-in Objects
]
Publication Date: 9/1/2000
|