Hi, actually in my database, I want to put password.
On my form I have two fields, One is combo box, which has names, and other one is text field, where they are going to enter date.
Now what I want to do, when some one select name from List box then he should enter data as well. Right now, when I double clik on the text box then enter password box comes up, and if password is correct then they can enter date, if not correct then I want to protect the text box, so theyc an't enter date.
Right now I have these following codes for password form.
If (Forms!frmPassword!txtpwd = Forms!frmPassword!txtverifypwd) Then
DoCmd.Save acForm, "frmApproval"
End If
If (Forms!frmPassword!txtpwd <> Forms!frmPassword!txtverifypwd) Then
Beep
MsgBox "Wrong Password", vbCritical, "Enter Passsword to Sign ECN"
End If
Thanks in Advance
On my form I have two fields, One is combo box, which has names, and other one is text field, where they are going to enter date.
Now what I want to do, when some one select name from List box then he should enter data as well. Right now, when I double clik on the text box then enter password box comes up, and if password is correct then they can enter date, if not correct then I want to protect the text box, so theyc an't enter date.
Right now I have these following codes for password form.
If (Forms!frmPassword!txtpwd = Forms!frmPassword!txtverifypwd) Then
DoCmd.Save acForm, "frmApproval"
End If
If (Forms!frmPassword!txtpwd <> Forms!frmPassword!txtverifypwd) Then
Beep
MsgBox "Wrong Password", vbCritical, "Enter Passsword to Sign ECN"
End If
Thanks in Advance