ADO search (w/o using datagrid)

[mklove999]

I'm really new in ADO for just a substitution on Data Control (I cannot dl any access 2003 D:)

---
Whenever I enter command3, it says:

Compile Error:
Method or data member not found

and the highlighted one was .EOF

Code:

Private Sub Command3_Click()
Adodc1.Recordset.MoveFirst
Adodc1.Recordset.Find "SID = '" & Text1.Text & "'"

If Adodc1.EOF Then
MsgBox "Not found"

===
All opinions are appreciated, I'll just try them one by one. I'm just a student, and this ADO thingy didn't teach us in school so I just need some help for our project :D