.asp and access2003

[pudgman]

I have an .asp site reading and writing to an access db. the problem i cant figure out is one of the tables in the database i call ID_NO. i have an add, delete and update page for the database. I figured out through recordsets how to display info from database. is there a way i can input the ID_NO into a field and search for that exact iformation from database to be displayed. right now i have it that i can page through but i have to go through all database ID_No's to get to the one im looking for. any help would be appreciated

[burtonfigg]

Could have this on the form:

[HTML]<html>
<body>
<form action="this.as p">
<input type="text" name="id">
<input type="submit">
</form>
</body>
</html>[/HTML]

and for this.asp:

<%
id = request.form("id")

SQL = "SELECT * from your_table WHERE ID_NO = "&id
set opRS = oConn.Execute(SQL)

if NOT opRS.EOF then
... display the stuff you need to...
end if
%>