T
Tom Wickerath
Hi Deepak,
Set the Allow Edits property on the form to No. To see this property, open
the form in design view. Click on View > Properties (or press F4 if using
Access 2002 or later). You should see the name of the form in the blue title
bar of the properties dialog. If not, click on the small black square in the
upper left corner of form design. Then select the Data tab. You should see
the Allow Edits property.
Alternatively, if the recordset is based on a query, you can set the query
property that reads "Recordset Type" as snapshot. Be aware, however, that
this property is not included in the SQL statement that represents the query.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
Hi
I want to lock record in a form after entering data in it.
Kindly help
Regards
Deepak
India
Set the Allow Edits property on the form to No. To see this property, open
the form in design view. Click on View > Properties (or press F4 if using
Access 2002 or later). You should see the name of the form in the blue title
bar of the properties dialog. If not, click on the small black square in the
upper left corner of form design. Then select the Data tab. You should see
the Allow Edits property.
Alternatively, if the recordset is based on a query, you can set the query
property that reads "Recordset Type" as snapshot. Be aware, however, that
this property is not included in the SQL statement that represents the query.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
Hi
I want to lock record in a form after entering data in it.
Kindly help
Regards
Deepak
India