Re: [MSAccessProfessionals] Add lock key to records..

My first thought is to toggle the Allow Edits property of the form based on that field, in the current event. 

Paul

Sent via mobile device

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of michael simpson via groups.io <saccity101=yahoo.com@groups.io>
Sent: Sunday, December 28, 2025 10:20:23 AM
To: msaccessprofessionals@groups.io <msaccessprofessionals@groups.io>
Subject: [MSAccessProfessionals] Add lock key to records..

 

I would like to add a lock to records once an invoice is sent out.. to prevent accidental changes.  

My first thought is to add a field (Lock) to each record and then add a before update procedure on each field, many of the fields also have after update procedures, 

Can I use both Before and After update procedures, 

Is there a better way to lock down records. 

Take care,

Mike the Plumber

Sac City Plumbing

._,_._,_