Access 2002 Programming by Example

Using Forms to Control Editing and Save Records

In a single-user environment, one might be tempted to think that Access can handle tasks such as saving records in a form, especially when you consider that Access automatically saves the record you are adding or editing as soon as you move the insertion point to a different record, or close the current form. This all changes in a multiuser environment. Do you want two or more users to be able to access the same record simultaneously and save their changes? It depends on what you want to do. Table 21.3 explains the differences in the three RecordLocks property settings on a form.

Table 21.3. RecordLocks Property Settings

Property	Value	Comments
No Locks	0	This property often is referred to as ...