I have an input textbox (txtUser) and a dbList (XUser) with the names of the already registered users. Now if a new user wants to register I want to check if the name he wants to use is already in use, in order to advice him to choose another name. The data is stored in an Acces database and the control is a common data Control. That works fine, so the only problem at the moment is the check-code.
Public Sub Continue_Click()
If TxtUser <> "" _
And txtFirstName <> "" _
And txtName <> "" _
And txtPassword.Text = txtConfirm.Text Then
' here would be the check-code, something like select
' case or do while ...
MsgBox "OK", 0, ""
Data1.Recordset.Update
Krit = "User='" & XUser & "'"
frmSFlash.Data1.Recordset.FindLast Krit
frmSFlash.Show
Unload Me
End If
End Sub
Can anybody help?
Thanks
Fritz
Public Sub Continue_Click()
If TxtUser <> "" _
And txtFirstName <> "" _
And txtName <> "" _
And txtPassword.Text = txtConfirm.Text Then
' here would be the check-code, something like select
' case or do while ...
MsgBox "OK", 0, ""
Data1.Recordset.Update
Krit = "User='" & XUser & "'"
frmSFlash.Data1.Recordset.FindLast Krit
frmSFlash.Show
Unload Me
End If
End Sub
Can anybody help?
Thanks
Fritz