Ms Office Tune Up

It’s sometimes useful to create a form that only displays the data in its associated record source. For example, in a table of financial data from a previous fiscal year where the books are closed, you wouldn’t want anyone to add, edit, or delete table data. In such situations, you can configure the form to prevent additions, deletions, edits, or any combination of these three actions. Here’s how:

1. Open the Design view for the form you want to work with (right-click the form in the Navigation pane and then click Design View).
2. Choose Design, Property Sheet to open the Property Sheet pane.
3. In the Selection Type list, click Form.
4. Click the Data tab.
5. Adjust the following properties, as needed (in each case, double-clicking the property toggles its value between Yes and No):
   • Allow Additions-Set this property to No to prevent users from adding new records.
   • Allow Deletions-Set this property to No to prevent users from deleting exist­ing records.
   • Allow Edits-Set this property to No to prevent users from making changes to existing records.
6. Close the Property Sheet pane and save your changes.

Technorati Tags: preventing changes, form data source, access2007

Popularity: 2% [?]