Locking Columns In A Query

<< Click to Display Table of Contents >>

Navigation:  Queries  >

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.

 

201203_gr_collock
Figure 1 - Adding Space locks the column from data entry

 

201203_gr_collock2

Figure 2 - Only the Rocktype field can be edited

 

Note: Tempvars are used to filter the data