Locking Columns In A Query

I wanted to lock a column in a query and I just couldn’t be bothered making a a form. Then it occured to me I could add a blank space into the columns that I wanted locked and the user wouldn’t be able to inadvertantly change data in those columns.  You will see how it works in the following 2 samples. The user can only change the data in the last column.

Figure 1 – Adding Space locks the column from data entry

Figure 2 – Only the Rocktype field can be edited


Note: Tempvars are used to filter the data

About Garry Robinson

He is the guy who originally put this Smart Access web site together. Head to www.gr-fx.com.au for more about him and his company. His main claim to fame is winning the Microsoft MVP award for services to MS Access from 2006 to 2018.
This entry was posted in Queries. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.