D
Danny
the following code works to filter on one field for a recordset:
Public Function FilterFieldNo(rsTemp As ADODB.Recordset, strField As String,
strFilter As Integer) As ADODB.Recordset
'open a new recordset object
rsTemp.Filter = strField & " Like '" & strFilter & "'"
Set FilterFieldNo = rsTemp
End Function
how can i modify the above code to filter on two fields of a recordset.
Public Function FilterFieldNo(rsTemp As ADODB.Recordset, strField As String,
strFilter As Integer) As ADODB.Recordset
'open a new recordset object
rsTemp.Filter = strField & " Like '" & strFilter & "'"
Set FilterFieldNo = rsTemp
End Function
how can i modify the above code to filter on two fields of a recordset.