Share this Page URL

Chapter 7. Designing Basic Forms > Viewing Data in a Form - Pg. 234

Designing Basic Forms Q. Can you create a form based on more than one table? 234 A. Yes, you can add fields from more than one table in the first screen of the Form Wizard if the tables are related. Working with the Views and Structure of a Form Before we continue with hands-on work designing forms, we'll examine some of the characteristics of a form--the different views you can set for a form, the parts of a form, the property that controls the records a form displays (the Record Source property), and the property that connects a control to a specific field (the Control Source property). Viewing Data in a Form Forms have a property named Default View. This property specifies whether a form displays its data one record at a time (set the Default View property to Single Form), as a series of records (set the Default View property to Continuous Forms), or in a datasheet (set the Default View property to Datasheet). (You can also use the Default View property to display a form's data as a PivotTable or PivotChart, which we'll cover in detail in Chapter 11.) Figure 7-1, shows the Expenses form open in all three views (we used copies of the form to show the views simultaneously) so that you can get a sense of how this property affects the way a form displays data.