Please, next time TELL US WHAT LINE the error is on, so we don't have to count lines.
Okay, so the error is here:
Did you bother to debug? Did you bother to see if, indeed, the record set *IS* open?
You really don't think that the ASP engine is making a mistake, do you?
Anyway, look carefully at your code: The only time you OPEN the recordset is after this code:
If Request.Form("Submit") = "Test" Then
And then only if the condition is true.
*CLEARLY* the first time you reach this page, that will *NOT* be true, so clearly until the <form> is submitted, the recordset WILL NOT BE OPEN.
I'm trying really hard to see what the point of your code is, but I can't. You do a WHILE loop on the recordset, but NO PLACE AT ALL inside the loop do you even TRY to get any values from the recordset. So the whole loop seems utterly pointless.
I really have no idea what you are trying to do here, so I have no idea how to help you.