Code for username and password for login userform

[jarrallian]

Thnx for your help man. Now I have another situation.

I have the following:

1. Login form containing username and password fields.
2. Data entry form

I want to do the following:

1. Coding for username and password fields, which, If the login is successful, takes me to DATA Entry Form, Otherwise shows message "Invalid Login".

Thanks in anticipation.

 

[Noz2k]

On the click event of a command button you could use something like the following.

If txtUsername.value="USERNAME" Then
If txtPassword.value="PASSWORD" Then
frmDataEntry.Show
Else MsgBox "Invalid Password"
End If
Else Msgbox "Invalid Username"
End If

 

[jarrallian]

Thnx man. it's so nice of you. it really works.