- Joined
- Apr 10, 2013
- Messages
- 2
- Reaction score
- 0
I have a tabbed that contains a form NavigationSubform (this was auto-named so I don't know if it goes in the syntax for what I'm trying to do)
I am concerned with a form named Suspend_Trending_Dashboard. A chart on this form is named chart. When the form loads, I don't want the query that is the rowsource of the chart to run in order to speed up the database. I have two text boxes for begin and end dates. These boxes are the criteria for the query the chart is based on. Then i have a command button that changes the rowsource of the chart to the query.
How do I get the command button on click event to changed the chart rowsource from nothing to a query after putting dates in the beging and end date text boxes on the form?
I had this code in the onclick event that worked, but now it won't:
When I click the button my form goes blank. I've attached before and after pics.
thank you
I am concerned with a form named Suspend_Trending_Dashboard. A chart on this form is named chart. When the form loads, I don't want the query that is the rowsource of the chart to run in order to speed up the database. I have two text boxes for begin and end dates. These boxes are the criteria for the query the chart is based on. Then i have a command button that changes the rowsource of the chart to the query.
How do I get the command button on click event to changed the chart rowsource from nothing to a query after putting dates in the beging and end date text boxes on the form?
I had this code in the onclick event that worked, but now it won't:
Code:
Forms!Navigationfrm!NavigationSubform.Form.RecordSource = "suspend_trend_CHART"When I click the button my form goes blank. I've attached before and after pics.
thank you