select part_no, vendor_part, vendor, descript1, media, cpu, dealer as Price FROM CATALOG where part_no ='" & strValue & "'"<BR><BR>This line pulls a line from my db where the part number = a value passed to it by a form. Hope this helps.
On one page you need the forms you are going to search by. So if they were text boxes they would read:<BR><BR>First Name:<BR><BR><input NAME="firstname" SIZE="50" MAXLENGTH="100" ><BR><BR>Last Name:<BR><BR><input NAME="company" SIZE="50" MAXLENGTH="100"><BR><BR>Then you need to pass these values to the display page. The display page will look like so:<BR><BR>DSN = Userdatabase<BR>TABLE = names<BR>FIELDS = firstname, lastname<BR><BR><BR> <%<BR> Dim Sqlstring<BR> Sqlstring = "SELECT firstname, lastname FROM names WHERE firstname='" & Request.Form.Item("firstname") & "' OR lastname='" & Request.Form.Item("lastname") & "'"<BR><BR> Dim conn<BR> Dim UserRecordset<BR> Set conn = Server.CreateObject("ADODB.Connection")<BR> conn.open ("Userdatabase")<BR> Set UserRecordset = Server.CreateObject("ADODB.Recordset")<BR> UserRecordset.Open Sqlstring, conn<BR> <BR> Set objfirstname = UserRecordset("firstname")<BR> Set objlastname = UserRecordset("lastname")<BR> If UserRecordset.EOF Then<BR> %><BR><BR>Then you write out your results:<BR><BR><%=objfirstname%><BR>� 60;%=objlastname%>