Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I change a report or chart RowSource SQL at run-time (dynamically)?

April 26, 2017chart dynamically report rowsource run-time sql

0

Posted

How can I change a report or chart RowSource SQL at run-time (dynamically)?

1 Answer

0

Posted

If you have a report based on form parameters, and/or one that uses the TOP clause, then you can set the RowSource property SQL in the Report_Open event. See Access FAQ 24 How do I select the top/bottom rows of a query dynaset?, the extra bit added April 2010. Me.RecordSource = strSQL ‘where strSQL = a string variable in which you have set up the required SQL However, setting the SQL in the RowSource property for a chart isn’t as simple. I tried using various events to set this property, but without any luck.