Changing RowSource of chart on a report from a form

[zplatt98]

Currently, I am trying to adjust the RowSource of a chart when a user clicks a print chart button to the dates the user has selected from a form. The chart is called "particleChart" and the report is named "particleDistributionChartReport" and I am trying to open it using this code:
DoCmd.OpenReport "particleDistributionChartReport", acViewPreview, , Reports![particleDistributionChartReport].Controls!particleChart.RowSource = "SELECT [Pan],[30Mesh], [35Mesh], [40Mesh], [60Mesh], [80Mesh], [100Mesh], [FormDate] FROM [tblResin] WHERE [FormDate] Between #" & Format(Me.startDate, "mm\/dd\/yyyy") & " # And # " & Format(Me.endDate, "mm\/dd\/yyyy") & "#"

Any tips on the syntax would be awesome, thank you!

[pbaldy]

That argument is to limit the record source of the report. It would look more like:

http://www.baldyweb.com/wherecondition.htm

In you case, why not have the query underlying the chart get criteria from the form where the user enters them?

[zplatt98]

How would I go about solving it that way?

[pbaldy]

In the criteria of the query you'd have

Between Forms!FormName.StartDate And Forms!FormName.EndDate

replacing FormName with the actual form name.