find method in ADO

[c_jeyasree]

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.

[Macintosh]

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]