Thanks John - How do I get rid of the extra "Drop Filter Fields Here" and "Drop Series Fields Here" options? Otherwise this is working very well for my purposes.
Dawn Crosier Application Specialist "Education Lasts a Lifetime" -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Thursday, January 05, 2006 9:11 AM To: [email protected] Subject: RE: [ms_access] Use a Form to Automate a Report (Chart) Dawn- Create a new blank form and set its Record Source to the query that provides the data for your chart. From the field list, drag and drop text boxes onto the form for the fields that provide the data for your chart. Set the Default View to Pivot Chart and disallow other views. Switch to PivotChart view and design the chart you need. Save the form and embed it as a subform/subreport in your main report. Use the Link Master / Link Child properties to further filter your chart data if necessary. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
