• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Advanced Form Design > Working with PivotChart Forms

Working with PivotChart Forms

Even when the main purpose of your application is to enter, store, and organize data to support an active business function, you probably want to add features that allow management to analyze the business processes. PivotTables and PivotCharts are ideal for this purpose. In Chapter 8, you learned how to create the PivotTable and PivotChart views of a query. Designing the PivotTable or PivotChart view of a form is exactly the same with some interesting twists:

  • You can use any query or table as the record source of the form, but only fields bound to controls on the form are available to design the PivotTable or PivotChart.

  • You can set form properties to control what the user can modify in the PivotTable or PivotChart view, including locking the form so they can’t modify what you designed at all.

  • Because a form has event properties, you can control what the user can modify by writing a Visual Basic procedure to respond to the event.

  • You can embed a form designed in PivotTable or PivotChart view as the subform of another form and set the Link Child and Link Master properties to filter the table or chart to display information relevant to the record on the outer form.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint