Hi everyone!
I am doing a form with some info that it's confidential for some users and it just should be available for the ones who has the password according to their user
What I want is once the form will be opened this textbox shows the field in password format and when the password will be get in makes the change to "normal" format
I don't remember making this change on code, only I remember like Format(Field, ) and cannot find more info
I highly appreciate the help
'******************
'Form 1
'Login
Private Sub UpdateLoginInfocmd_Click()
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Form2"
stLinkCriteria = "[User]=" & "'" & Me.Usertxt & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
'I also want to open both on password format
[Forms]![Form2]![SafetyQuestion].Enabled = False
[Forms]![Form2]![SafetyAnswer].Enabled = False
End Sub
'Form 2
Private Sub Passwordtxt3_AfterUpdate()
If Me.Passwordtxt3 = Me.Password Then
'Here I want to get back the "normal view" and take the password view out
Me.SafetyQuestion.Enabled = True
Me.SafetyAnswer.Enabled = True
Else
Me.SafetyQuestion.Enabled = False
Me.SafetyAnswer.Enabled = False
End If
End Sub
'**********************
Thanks in advance for the help!!!