![](https://vb123.com/wp-content/uploads/2018/08/201203_gr_collock.png)
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