Microsoft® Office Access 2003 Inside Out

Setting Recordset Type

In Chapter 12, you learned how to set the Allow Edits, Allow Deletions, and Allow Additions properties of a form to restrict what data the user can update via the form. When you want to disallow all edits, deletions, and additions in a form in an Access project, you can also change the Recordset Type property. By default, the Recordset Type property of a form in a project is Updatable Snapshot. As long as Access determines that the record source of the form is updatable, the user is able to edit, delete, and add records using the form. However, when you change the Recordset Type to Snapshot, the form becomes read-only.

To see an example, open the frmXmplZIPReadOnly form in the LawTrack Contacts project file. Figure 19-6