Fields that cann't Edit in datasheet view

[nandamurisrihari]

Hi,

how can i stop editing only one field outof many fields which are editable displayed in data sheet view which was generated from temporary table in msAcess.


Regards
N.SRIHARI

 

[dakota81]

In the design view of the form, pull up the properties of the field you want to lock and set the lock property to Yes.

 

[nandamurisrihari]

Hi,
Iam assigning temporary table to subform in which i need to lock one field.
its like DetailSubform.SourceObject = "table.tmporarytable"
and this temporary table will be populate in subform with so many fields of which i can hide ,freeze,sorby and all those things..but how can i lock a field???

As u said it will lock all fields in a subform,but not one field.

Thanks and Regards
N.SRIHARI