Share this Page URL

Chapter 7. Designing Basic Forms > Creating a Form with the Form Wizard and Aut... - Pg. 232

Designing Basic Forms 232 11. Notice that the Expenses form indicates that the records are filtered. When it builds the forms, the Form Wizard uses the CampaignID field--the field that relates these tables--to filter and synchronize the records that the two forms display. Close the Expenses form and the CampaignInformation form for now. You could use the CampaignInformation and Expenses forms to create or update information about a current campaign (including deleting a campaign), to view expense information, to record a new expense for a campaign, and other operations. We could improve these forms by displaying the employee's last name rather than the employee ID number (which is the value stored in the Mar- ketingCampaigns table), by adding the campaign language to the data displayed by the Cam- paignInformation form, and by viewing expenses in Datasheet view, which would display more than one expense record at a time. We'll describe how to make modifications such as these later in this chapter. First, we'll cover how to create a form using an AutoForm format. Create a form using an AutoForm format 1. In the Database window, click Forms in the Objects list, and then click New. You'll see the New Form dialog box, shown here: