Setting properties on a new record

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

Guest

I am currently working in an access form. I have "password" protected 2
fields (Date Approved and Status) by writing the following code that requires
the password "test" be typed into the Password field:

Private Sub Password_AfterUpdate()
If Me.Password = "test" Then
Me.Date_Approved.Enabled = True
Me.Status.Enabled = True
Else
Me.Date_PMP_Approved.Enabled = False
Me.Project_Status.Enabled = False
End If
End Sub

The Date_Approved and Status fields are set by defualt to be disabled, so
they are only turned on when the correct password is entered. However, once
the password is entered they are unlocked in EVERY record. I would like
these fields to reset as being disabled once the user moves to a new record
in the access form. I'm sure there is an easy way to do this, but I'm
definitely a beginner. Any help is appreciated in advance.
Thanks!
 
Use the Form's current event to reset the properties

Private Sub Form_Current()
Me.Date_PMP_Approved.Enabled = False
Me.Project_Status.Enabled = False
End Sub
 
Thanks for the quick response!

John Spencer said:
Use the Form's current event to reset the properties

Private Sub Form_Current()
Me.Date_PMP_Approved.Enabled = False
Me.Project_Status.Enabled = False
End Sub
Click to expand...
 
Back
Top