ACC: Form Is Editable Even When AllowEdits Property Set to FalseLast reviewed: August 29, 1997Article ID: Q167420 |
The information in this article applies to:
SYMPTOMSModerate: Requires basic macro, coding, and interoperability skills. When you open a Microsoft Access form that has the AllowEdits property set to No (False), you can still edit the fields on that form. This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Visual Basic for Applications, please refer to your version of the "Building Applications with Microsoft Access" manual.
CAUSEThis behavior occurs if you set the value of a control programmatically in the Current event of the form. It also occurs if you set the value of a control in the Load event of the form. In that case, however, the only record that you can edit is the first record that is displayed on the form.
RESOLUTIONIf you need to edit the values of bound fields programmatically in forms that have the AllowEdits property set to False, edit those fields in the RecordsetClone of the form, and not in the form itself. The following example demonstrates how to create Visual Basic code in the Current event of a form that can change the values of fields in the RecordsetClone of a form. CAUTION: Following the steps in this example will modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and perform these steps on a copy of the database.
MORE INFORMATION
Steps to Reproduce Behavior
REFERENCESFor more information about the AllowEdits property, search the Help Index for "AllowEdits property," or ask the Microsoft Access 97 Office Assistant. For more information about the RecordsetClone property, search the Help Index for "RecordsetClone property," or ask the Microsoft Access 97 Office Assistant. Keywords : kbusage FmsProp FmsEvnt Version : 7.00 97 Platform : WINDOWS Hardware : x86 Issue type : kbprb Solution Type : kbworkaround |
================================================================================
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |