Chapter 6. Forms

Open a form

To open an existing form click on the forms icon on the left hand side of the screen. Then double click on the name of the form you wish to open. Alternatively you can right click on the name of the form and then click on Open.

Create and save a form

To create a form based on a table, first click on the forms icon on the left hand side. Then click on Use Wizard to Create Form. Figure 20 illustrates the first screen of the wizard.

Figure 6.1. Screen 1 of the Form Wizard

Select the table you wish to base the form on by selecting it from the drop down box under Tables or queries. Next select the fields you want the form to contain by clicking on them and clicking on the > to move them across. If you want to select all fields click on the double arrow >> and this will move all the fields across. Click the Next button. The second screen of the wizard is to do with creating a subform. As we do not want to do this at this stage leave it as it is and click the Next button.

Figure 21 shows the next screen of the wizard.

Figure 6.2. Arranging the controls on the form

Choose the label placement and layout that you want and click Next (Figure 22).

Figure 6.3. Select the data entry mode

Click on Next (Figure 23).

Figure 6.4. Apply a style to the form

Click Next to go to the final screen of the wizard (Figure 24).

Figure 6.5. Set the name of the form

Click on Finish to complete the setup of the form.

Use a form to enter, modify, delete records

Once the form has been created you can use it to enter data.

Double-click the form to open it for entering data. Enter the data by clicking in the box next to the field name and entering the relevant information. If you wish to make changes to a field, double-click in that field and make the necessary changes. If you want to delete a record click on the delete record icon on the Form toolbar at the bottom of the screen.

Go to next record, previous record, first record, last record, specific record using form display

To navigate between the various records in the form, use the arrows on the Form toolbar at the bottom of the screen (Figure 25). These arrows look and function in the same way as those in the editing table screen.

Figure 6.6. Form Toolbar

Add, modify text in Headers, Footers in a form

FIX ME

Delete a form

If you want to delete an existing form right-click on it and select Delete from the drop-down options.

Save and close a form

When you have finished with the form click on the save button. Close the form by clicking on the close icon (X) or by clicking on File > Close.


Chapter 5. Exercise 3		Chapter 7. Exercise 1