I need help with a Microsoft Graph within a form. When I use a pivot chart it works, however, it does not keep the changes I make and continues to default back on update. So, I am trying to utilize the Microsoft chart which is a unbound object. I have a form that has a drop down combo that tells all the data within the form to change data by month. My graph is within a subform. Because it is an unbound object I am not able to tell the 2 forms to talk to each other by month. I am attaching an example. I need the chart to change by month. Any help will be appreciated. Do I need a macro? If so how would I do that?
in the subform the record source of the graph should be pointing to the combo box
What i do is open both forms
then open the record source of the graph which will open a query window
them in the Criteria right click and click the build then select the forms them the Loaded forms then the from then double the the feild(combo box) then ok
close the query window click yes save
we need to repaint the subforms
so in the afterupdate event
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
Ok. I tried what Mylie advised. Here is what I did, I must be doing something incorrectly:
1. I opened the subform graph1 in design view and the form FSMonthly Summary,Then I clicked on the unbound object and went to the record source and opened the query FSgraph. Within the criteria under "month" I did a right click on build and went to loaded forms. I found the combo box option and clicked on it. I now have the following criteria: Forms![FS Monthly Summary]![Combo237]. I save the form. Now when I go back to the form FSMonthly Summary that has the subform graph1 within it. The graph is greyed out and does not like what I did at all. So.......What did I do incorrectly?
Still having no luck... I tried both options. When I add Forms![FS Monthly Summary]![Combo237].Value within the (month ID) query field I still get a grayed out graph. It doesn't even show the graph. When I tried the 2nd option: Forms![FS Monthly Summary]![Combo237].Colum(2) (note: I used 2 since that is the index number of the combo box) I get an error dialog box that says the following: Undefined function 'Forms[FS Monthly Summary]!Combo237.Colum' in expression. When I select OK, the whole subform is not showing at all it is totally white.