Part I: Access Building Blocks
310
TABLE 8.4 (continued)
Property Description Options
Allow Filters Determines whether a user will be able to
display a filtered form.
Yes/No
Allow Edits Determines whether a user will be able to
edit data, making the form editable or read
only.
Yes/No
Allow
Deletions
Determines whether a user will be able to
delete records.
Yes/No
Allow
Additions
Determines whether a user will be able to
add records.
Yes/No
Data Entry Determines whether form opens to a new
blank record, not showing any saved
records.
Yes/No
Recordset
Type
Used to determine whether multi-table forms
can be updated.
Dynaset: Only default table field controls
can be edited.
Dynaset (Inconsistent Updates): All tables
and fields are editable.
Snapshot: No fields are editable (same as
read-only)
Record Locks Used to determine default multiuser record
locking on bound forms.
No Locks: Record is locked only as it’s
saved.
All Records: Locks entire form’s records
while using the form.
Edited Record: Locks only current record
during an edit.
Fetch Defaults Determines whether default values should
be retrieved.
Yes/No
TABLE 8.5
Form “Other” Properties
Property Description Option Definition
Pop Up Form is a pop-up that floats above all other
objects.
Yes/No
Modal User must close the form before doing any-
thing else. Disables other windows. When
Pop Up set to Yes, Modal disables menus
and toolbar, creating a dialog box.
Yes/No
