here is my code:<br>-------------------------------------------<br><%@ Language=VBScript %> <br><html><br><br><head><br><meta http-equiv="Content-Type" content="text/html; charset=windows-1252"><br><meta name="GENERATOR" content="Microsoft FrontPage 4.0"><br><meta name="ProgId" content="FrontPage.Editor.Document"><br><title>New Page 2</title><br></head><br><br><body><br><% Response.Write("These records are pulled from an MS Access database" %> <br><%<br>Set Conn = Server.CreateObject("ADODB.Connection"<br>Conn.Open "driver=SQL Server;server=<A HREF=" TARGET="_new"> RS = Conn.Execute("SELECT *, STOCK_CODE AS Expr1 FROM [Copy-PartMaster Lite] WHERE (STOCK_CODE LIKE N'40016%')"<br>If Not RS.EOF Then<br> Do<br> Response.Write RS("STOCK_CODE" & " " & RS("DESCRIPTION"<br> Response.Write ""<br> RS.Movenext<br> Loop Until RS.EOF<br>Else<br> msgbox "Empty Baby"<br>End If<br>%><br><% do while not RS.eof %><br><%= RS(0) %> <br><% RS.movenext <br>loop%><br><br><% RS.close %><br><br></body><br><br></html><br>---------------------------<br>where is has "LIKE N'40016%" I would like to replace this with a variable of some sort like a text box on a WEB page form.<br>When I create a submit button what do I put in it.<br>I am using Front Page 2000 for WEB creation<br><br>TIA <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.