Share this Page URL

Organizing Your Data with Base 379 3. Click the Use Wizard to Create Form link, shown in the Tasks list on the right side of the Base window. The Form Wizard appears. Select Fields In Step 1 of the Form Wizard, select the table for which you're creating this form from the Tables or queries list. The fields in that table appear in the Available fields list. Select a field from the Available fields list that you want to use on the form and click > to add the field to the Fields in the form list. Repeat to add each field to the Fields in the form list. When you have identified all the fields you want to use in the form, click Next. To use all the fields in the table on the form, click >> instead. Arrange Controls Click Next again to skip Step 2, Step 3, and Step 4 (see Note for more information). In Step 5 of the Form Wizard, click the button under the Arrangement of the main form heading that represents the general layout you want for the data entry boxes on the form. After you click a button, the sample layout is displayed below the Form Wizard, in the actual form window. This arrangement allows you to preview each layout until you find the one you like. If you choose something other than the sheet layout (the third option), you can adjust the size and position of each control to suit your exact needs after the form is created. Click Next. If you want to be able to make changes to data in another table while entering data in this table, you can add a subform. This advanced feature is beyond the scope of this book. Steps 2­4 of the Form Wizard relate to the creation of a subform. Set Data Entry Mode In Step 6 of the Form Wizard, select the type of data entry mode you want and click Next. For example, if you intend to use the form to enter data but not to review it, choose The form is to be used for entering new data only. Existing data will not be displayed. If you want the user to be able to scroll through previously entered records using the form, choose The form is to display all data. Then choose any restrictions you want by enabling the appropriate check box. For example, to prevent a user from deleting previous records, enable the Do not allow deletion of existing data option. Click Next. Select a Background In Step 7 of the Form Wizard, select the background color you want to use from the Apply styles list. Again, as you select a color, you can see a preview of how your color selection will look on the actual form under the Form Wizard. Select how you want the border around each field to appear (such as 3D) from the Field bor- der options on the right side of the wizard window. Click Next. Name the Form In Step 8 of the Form Wizard, type a name for the form in the Name of the form text box, or simply leave the suggested name as is. To start entering data into your table using the form, choose Work with the form. (See 139 Enter Data Using a Form.) To make changes to the form before you use it, choose Modify the form. (See 138 Modify a Form.) Click Finish. The form is created and displayed in a window. NOTE TIP 4. 5. 6. 7. Modify a Form BEFORE YOU BEGIN 137 Create a Form