Form Protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I searched the community and found no solution to the problem I am
having.... please help.

I have a form for assessment. Each line item has a default level of risk. A
user enters the level of importance and a grade is given. Currently, the
level of risk: enabled=no, so it is grayed out. That's fine.
I want to be able to enable those fields with a command button and a
password, and have a finished button (which only appears when the form is in
edit mode), so it can return to normal.

Can this be done?

Thanks.
 
Yes. This can be done. I will need to know the forms Default View: Single
Form or Continuous Forms?


Ruel
 
The Default View is Single Form, but the text boxes that need to be changed
are on two different tabs (There are 5 tabs in all).
Thanks.
 
As Doug said, unless you're speaking of subforms on tabs it doesn't matter.
References to controls on tabbed pages are exactly the same as if they were
all on one "screen." Think of tabbed pages as a really long form, turned
sideways!
 
Create a Toggle Button with the label "Enable Fields". Then create an
OnClick Procedure that looks like this:

Private Sub Toggle1_Click()
If Me.Toggle1 = 0 Then
Me.Toggle1.Caption = "Finished"
Me.Importance.Enabled = True
Me.Grade.Enabled = True
Else
Me.Toggle1.Caption = "Enable Fields"
Me.Importance.Enabled = False
Me.Grade.Enabled = False
End If
End Sub


Ruel
 
Back
Top