First is the Login form
-----------------------
<html>
<%@ Language=VBScript %>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Login</title>
</head>
<body>
<form action="tableof.asp" method=get>
<p align="center"><font size="5">Distributor Login Form</font></p>
<p align="center"> Login <input type="text" name="login" size="20"></p>
<p align="center">Password <input type="text" name="password" size="20"></p>
<p align="center"><input type="submit" value="Submit" name="LoginButton"><input type="reset" value="Reset" name="B2">
</p>
<p align="center"><font size="2">Powered by SQL Server 7<br><br>
written by: Douglas Poston<br>
<a href="mailto:dposton@universal1.com">dposton@universal1.com</a>
</font>
</p>
</form>
</body>
</html>
----------------------------------
Second is the accepting page
----------------------------------
<html><head>
<TITLE>Parts Lookup.asp</TITLE>
</head><body bgcolor="#FFFFFF">
<%pass=request.querystring("password"

%>
<br>
<%
Set Conn = server.CreateObject("ADODB.Connection"

Conn.Open "driver=SQL Server;server=yoursite.com;uid=user;pwd=pass;database=YourDatabase;"
Set RS1 = Conn.Execute("SELECT * From Customers Where [CUSTOMER] ='" & pass & "'"

%>
------------
This is looking up a password in a SQL server database
---------
The <input type="text" name="password" ... is the value being passed to the second page and it is received into
<%pass=request.querystring("password"

%> on the second page.
So the ...request.querystring("password"

... has to match exactly as the name of the text box on the first form.
DougP, MCP
Visit my WEB site
to see how Bar-codes can help you be more productive