whats the error? Type Mismatch? If so you did this
change it to thisCode:SearchSting = "User = '" & Trim(txtUser.Text) & "'" And "Pass ='" & Trim(txtPass.Text) & "'"
for your other questionCode:SearchSting = "User = '" & Trim(txtUser.Text) & "' And Pass ='" & Trim(txtPass.Text) & "'"
just put in your else for when login is correct
userGroup = txtUser.Text




Reply With Quote