Yes Matt,
There is a refresh problem there in report. After changing datasheet, preview report with wrong values, just click on report page to change zoom or from toolbar go to page 1 and you get the changes reflected. I have no practical solution for the moment.
Cetin
>I am not creating the graph object in code at run time. The graph was created with the graph wizard, and I have an ole bound control on the form, then I programmatically change the data cells, then set .visible=true to display it on the form. I prefer to set chart settings by double-clicking the ole graph object after it is displayed on the form, then setting properties that way instead of by program code. When I re-fill the cells, I hide the ole, then fill the cells, the display the ole with updated data. All this works fine.
>
>Problem is, when I "report form preview" the graph to print print it, the first time it works fine. If I make changes to the data, the form ole graph is updated, but then preview the report, and the new graph does not show up on the report, even though it showed up on screen. The report field is bound to the same general field as the form's ole control. In order to make the report in synch with the form ole graph, I have to double-click the ole, then exit the graph edit mode, then the report will show the new data.
>
>
>
>
>>>If you have a graph on the form, and you programmatically change a cell value, how do you update the general field so as to make the graph update since a cell value got changed.
>>Matt,
>>It's like changing a "word" in an embedded word doc on form. When you change cell value, in fact you're changing graph object. So embedded data is updated. Remember syntax to create graph object :
>>append general myOLE class "msgraph" data MCGDATA
>>MCGDATA was tab delimited datasheet and now you are changing datasheet ;) Only change cell value and Graph is refreshed on form (no need for a refresh) and data i updated :) BTW the sample you saw, had it a "Change some data", "Change graph type" commandbuttons ? That was demonstrating this also. If not lemme know I could send it too.
>>Cetin
