Make a field in a query locked
Posted on 2013-02-06
I have a query that runs in datasheet view and the user can edit the data. Is there a way to lock certain fields so they cannot be edited? I'm using the datasheet view and not a form since it's more familiar to the user.
Also, in the query result, does the field properties follow the table it's based on. ie...if the table that the query is based on is a combo box, will the query also display this field as a combo box. It seems to work in most situations but there is one field that does not follow this logic.