Locking a Record once its closed.

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

Hello,

I have a basic Access 2002 database created to track
tickets for my Help Desk. I have a field called Closed,
that is a Yes/No field.

Is there a way I can prevent the record from being edited
or changed once the record is closed?

Thanks and Happy New Year!

Steven
 
Put the following code in the form's OnCurrent event:

Me!Closed.Enabled = Not Me!Closed
Me!Closed.Locked = Me!Closed
 
Use the Form_Current Event to check whether Closed is Yes / True and if it
is, set the AllowEdits Property of the Form to False.
 
Back
Top