Password part of a Form and...

[pdavis27040]

Hi Everyone,

Is there a way to password protect a certain part of a form that can only be filled out by one particular user?

Also I posted a question about when a person clicks on a particular checkbox if a image at the top of the screen can appear. The gentlemen that replied helped out GREATLY but the only thing I havent been able to figure out is after the entire form has been feeled out and this particular text appears after the checkbox is completed and you move on to the next data entry the text stays there. Is there a way to set it to refresh if you unselect that option and when you go to the next record that it goes away??? I do appreciate it!!

Sincerely,
Paul

 

[WayneRyan]

Paul,

You can make a new "unbound" textbox and in its
AfterUpdate event you can:

If Me.MyTextBox = "The Password" Then
   Me.SomeField.Visible = True
   Me.SomeField.Enabled = True
Else
   MsgBox("Invalid Password")
End If

For the second part you can use the OnCurrent
event of your form and if Me.MyCheckBox = True
then you can make some control visible and
enabled.

Wayne