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

For a very (too?) simple implementation you can review the Northwind 2 Developer Edition template. Orders have Status, and orders with a Closed status cannot be modified.

 

-Tom.

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of michael simpson via groups.io
Sent: Sunday, December 28, 2025 11:20 AM
To: 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

 

._,_._,_