How to find a record using DataRow? (RESOLVED)

[AlvaroF1]

'myRS is a DAO recordset
myRS.FindFirst "FIRSTNAME='" & Text1.Text & "' AND LASTNAME='" & Text2.Text & "'"

How to write a code using a DataRow to find a record with the criteria above?


Thanks.

[janis]

Here we go:

'myRs is datatable
Dim objCurr() As DataRow
objCurr =myRs.select("FIRSTNAME='" & Text1.Text & "'
AND LASTNAME='" & Text2.Text & "'")

Dim c As DataRow
For Each c In objCurr
msgbox(c.item("FIRSTNAME").tostring & " " & _
c.item("LASTNAME").tostring)
Next

I hope that helps.

regard j

[AlvaroF1]

That helped. Thanx!

[janis]

No problemo.

regard j