How do I get the results of a query to show in text boxes? The query works and shows the results but it also adds all the other fields in the database after the matches. I only want matches to show.

Code:
'sql statement
with db
Set rs3 = db1.OpenRecordset("SELECT * " & "FROM [entered] WHERE [RiderNumber] = '" & listry.List(I) & "'", dbOpenDynaset)

With rs3
.edit
txtname = ![RiderName]
txtnumber = ![RiderNumber]
txtother = ![other]
end with
end with
Also How do you use the .findfirst method for numbers? If I use a number field it says data type conversion error.

Hope someone can help.


[Edited by chongo 2002 on 09-30-2000 at 08:35 PM]