[dba-SQLServer]ADO FInd and SQL Server

We need to pass multipe values to FInd or Filter in ADO.

Any ideas?

  rstBuilding.Open ("select * from tblBuilding"), cnn, adOpenKeyset, 
adLockPessimistic

        rstBuilding.Filter "fldClusterID = " & Val(Nz(txtClusterID)) & " AND 
fldBuildingNumber = '" _
            & Nz(txtBuildingNumber) & "'"


Martin