Alert of duplicate usename without losing form focus

[benniesanders]

Greetings,

I created a registration form and I have it checking for duplication of the username after it's submitted but is there a way to let the user know without losing all the info they've already entered into the form?

SQL = "SELECT * FROM myregistration WHERE myusername = '" & Request.Form("rusername") & "'"
If objConn.Execute(SQL).EOF Then
'   Add it to the database
else
response.write "This username already exists.  Please choose another."
end if

and then have it go back to the form? Many thanks for your thoughts.

 

[benniesanders]

Please disregard. I added a "go back" thingy to my alert. Works fine. Thanks.