problem in ADO find method

[c_jeyasree]

reference(my old query):-
friends, i have used vb 6.0 and ms access. i am using ADO type recordset. my requirement is to find match criteria on the basis of two fields: sample code: .Find "Month = " & 1 & " AND FmtFunct = '" & txtFormatId.Text & txtFunctionId.Text & "'" here my search criteria contains one numeric field and another character field which has to be searched simultaneously. it is not accepting.
reply from Macintosh(Junior Member):-

Assuming there is 2 fields in ur table to search field 1 - Month - numeric field 2 - FmtFunct - Text Dim strFmtFunct As String Dim Rs as New ADODB.Recordset strFmtFunct = txtFormatId.Text & txtFunctionId.Text Now use Rs.Open "Select * from TableName", Connection Rs.Find "Month = " & 1 & " AND FmtFunct = '" & strFmtFunct & "'" This will work.....
Error in detail(new note):-

but it did not work. the same error msg is recurring...

err.description
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.

err.number
3001

can anybody help?

friendly,
jeyasree.

[KevinD]

I had a similar problem - you have to use the 'Filter' method in VB 6.0 where more than one argument is used.