find method in ADO

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.

can you help me out.

friendly,
jeyasree.

Hi Jeyashree,

Hey Please try this to search

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.....

Best of luck.... In case any clarification feel free to raise a query....

Bye Bye

Murali
[email protected]