thanks man finally something that looks right but still i have an error
Private Sub Command7_Click()
If DLookup("Password", "WorkerT", "WorkerNumber = '" & Me.UserName & "'") = Me.Password Then
MsgBox "good"
Else
MsgBox "Your userid or password is invalid. Please try again.", vbOKOnly...
plz about the same problem it goes like this .
I want to make a field user field password and a button that will confirm if the user matches the password
the data comes from a table of users witch contains the username and password.
plzhow do i reffer to the table fields and confirm what i need...