Locking a Record once its closed.

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
 
P

PC Datasheet

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

Me!Closed.Enabled = Not Me!Closed
Me!Closed.Locked = Me!Closed
 
V

Van T. Dinh

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
How do I clear a form? 0
Crash on Close from 2 stable Access forms after unsolicited install of VS 2015 0
Using Microsoft Access as a Service Ticket Write-up program 0
locking a form once it has been entered 2
DMax on existing record to increment serialized # fails 1
Can a Check Box Prevent Other Fields from Being Used? 1
Error message when adding a new record 2

Top