hi TPM thanks for the reply. I figured out i need to just select with the *. This will return a row if it found something. but now the problem is even if i put the correct details in, it wont let me through to the next page.
code:
Private Sub Page_Load(ByVal sender As System.Object, ByVal...