I am using the following code to filter on a single field, which works fine.

For intType = 1 To intNumberofRecords
 strCriteria = "Type LIKE '" & strType & "*'"
 objRS.Filter = strCriteria
Next

However, if I want to filter first on one field, and then filter the results on another field criteria, can someone provide the coding to do this?

If I understand you correctly, you can just use AND and OR in your filter:

strCriteria = "Type LIKE '" & strType & "*' AND SomethingElse > 10"
objRS.Filter = strCriteria

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.