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

Perfect, thank you so much..

I am so glad that I asked questions.. 

Take care,

Mike the Plumber

Sac City Plumbing

On Sunday, December 28, 2025 at 10:58:02 AM PST, Paul Baldy via groups.io <pbaldy=gmail.com@groups.io> wrote:

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

._,_._,_