Let's get to some manual checks and printf debugging.

Hardcode the query in the db.
Does it work?

Then
Response.Write email
Response.End
After line 10.
This will check if you're getting an email from your request.

Please also look at using Parameters (Query String tip)

this small change fixed it.....

rs(password) => rs("password")

Right you want the field NAMED "Password" the the field named whatever the value of Password IS.

I thought putting quotes meant that I wanted the word password and without quotes i wanted the value of field password.....Do I have that backwards?

When you said rs(password) you were saying whatever value password had e.g. Fred2.
So rs("Fred2"), and Fred2 isn't a FIELD in your Table.

There's a few different ways to get it
objField = objRecordset.Fields.Item("ProductID")  
objField = objRecordset.Fields("ProductID")  
objField = objRecordset.Fields.Item(0)  
objField = objRecordset.Fields(0)

isnt that what i am trying to say:

if the value in the rsPassword filed is equal to the value of form's value  lets say ok that is good  rs Password value = forms Password value

Fred2=Fred2
rs(password)=password

??

I would thought that rs("password") = password
would be

password<>Fred2

and rs('password") = "password"

would be password=password (both the name not value)

Hi Dg, certain syntax requires a *literal* string value of "password" because a string is expected by that particular syntax.  But other times it doesn't, and isn't.  Access does the same thing.  The two lines below do the same thing.  But when a literal string is required, it needs the quotes:

     Me("MyFieldName") = "xxxx"
     Me!MyFieldName = "xxxx"

Using literal strings to refer to field names lets you manipulate them in ways that can make coding easier.  For instance, if you have the 20 field names MyField1, MyField2, MyField3, ... up to MyField20, and you want to assign each them a value, instead of writing 20 lines of code, you only need 3 lines of code with a For Next loop:

     Dim i As Integer
     For i = 1 to 20
          Me("Field" & i) = SomeValue
     Next i

Since the field name is a string, you can concatenate it with something else to turn it into something else.  You can't do that if you use the syntax Me!Field1, etc.