[RESOLVED] check record exists when find a record

how can i check record exists when find a record using

Rec.Find "Stno=" & txtStno.Text

if no record is there how can i check it

try this

VB Code:

Rec.Find "Stno = " & txtStno.Text
if not Rec.EOF then
    'the record exists
Else
    'the record does not exist
End If