.Find???? Methods

[chongo 2002]

How do you use the .findfirst .findnext etc commands to display search results?

txtsearch.text <-- what user eneters and the it needs to populate 3 more textboxes with reults

Name.text <--needs to show results name
Number.text <-- needs to show names number
Name2.text <-- needs to show names name2

[amcrae]

assuming you have a recordset rsTemp


with rsTemp
.Index ="PrimaryKey"
' I'm assuming the user enters the primary key?

.FindFirst txtsearch

if .NoMatch then
' not found in db
else
Name = !Name
Number = !Number
Name2 = !Name2
end if
end with

[chongo 2002]

i get an error on the primaty key. error 3800 not an indexed field. Any suggestions?