Adjusting Form Properties

From NeoWiki

Sometimes after you have designed a form, you discover that some of the form properties that you set in the wizard need to be adjusted. Other times, you may create a form in design view, without using the wizard at all, and need to set the form properties.

In the case of our birding database, I realized that when entering data on a field trip, it would be most helpful if the "Field Trips Data Entry" form pulled up with an empty form, rather than with data from a previous trip. To do this means changing the field properties.

Because I would like to also view existing data in the same format, we will first copy the form. To do so, right-click or control-click on the Field Trips Data Entry form and choose Copy. Then right-click or control-click on any blank area in the Forms section of the main database window and select Paste from the contextual menu. You will be asked to give the new form a name. I chose "Field Trips Data Viewing."

Changing the Properties of the Main Form

1. Right-click or control-click on the Field Trips Data Entry icon and choose Edit
2. Right click on any element of the form (a field or a label)
3. Now click on the Form icon on the toolbar (circled in red in the image below)

   

   Note that this button will be greyed out unless an element of the form has been selected. You can also access Form Properties by right-clicking or control-clicking on a form element and choosing Form.

4. Under the General Tab you may change the name if you like.

   Note that changing the name may affect the macro in Adding a Button To Open Another Form

5. Click on the Data Tab

   Note that you can set many properties of the form here, including what type of content (Table, Query, or SQL Command), which Table or Query it relates to, etc. Search the online help for more details on many of these settings

6. Allow Additions specifies whether or not you can add records. We want to leave this set for Yes. (If you wanted a read-only form, you would set it to No)
7. Allow Modifications specifies whether or not the form can be modified. Leave this set for Yes
8. Similarly, Allow Deletions should be left at Yes. (For other purposes, however, setting this to No helps to protect your data.)
9. Add Data only should be set to Yes

   Note: The Events tab allows you to assign Macros to various form-related events. These settings go beyond the scope of this tutorial.

10. Close the Form Properties window.

Changing the Subform Properties

Now we need to change the properties for our subform. This same process could be used for a main form set up as a data sheet.

1. Right-click or control-click on the small, untitled retangle in the upper right hand corner of the data sheet (just to the left of the first field name). Select Form... from the contextual menu.
2. Under the General Tab you may change the name if you like.
3. Click on the Data Tab
4. Leave Allow Additions set for Yes. (If you wanted a read-only form, you would set it to No)
5. Leave Allow Modifications set for Yes
6. Similarly, Allow Deletions should be left at Yes. (For other purposes, however, setting this to No helps to protect your data.)
7. Add Data only should be set to Yes

Check Your Work

Turn Design Mode off by clicking on the blue drafting triangle. Verify that:

the "Next Record" and "Previous Record" buttons are dimmed.

you can add Data