Creating A Data Entry Form With A Subform

From NeoWiki

Revision as of 02:26, 14 September 2007

The data entry form the birder will use on return from a field trip must allow for data entry into two different tables: The Field Trips table and the Sightings Table. For every record in the Field Trips table, there will be multiple entries in the Sightings table. So we need to create a form based on the Field Trips table with a sub-form based on the Sightings table.

1. Open the database document
2. Click on the Forms icon in the left column of the main database document window
3. In the Tasks section, click on Use Wizard to Create Form...
4. In the Tables or Queries drop-down, choose Table: Field Trips
5. Click on the >> button to move all the field over
6. Use the up or down arrow buttons to change the field order if need be
7. Click Next>
8. Check the Add Subform checkbox
9. Click in the Subform based on existing relation radio button
10. Select Sightings in the box next to the question Which relation do you want to use?
11. Click Next>
12. Note that the correct table is chosen in the drop-down
13. Click the >> Button to move all the fields over
14. Use the up or down arrow buttons to change the field order if need be
15. Click Next>
16. Choose the Arrangement of the main form I chose the option furthest to the right, labeled In Blocks-Labels Above
17. Choose the Arrangement of the subform I reccommend the third option, labeled As Data Sheet
18. Click Next>
19. Set the Data Entry Mode. I set it for This form is to display all data and left all the boxes unchecked.
20. Click Next>
21. Select the background color and style you want.
22. Click Next>
23. Enter the name of the form, and decide if you want to work with it (i.e. enter data) or modify it (i.e. edit the layout).
24. Click Finish