Requery a Chart in a Sub Form?

[Robert G]

Hello,

I am struggling a bit .
I have a main form which holds a subform.
The subform has a chart.
The Data for the chart is manipulated within a script from the main form
I use then the following code to requery the subform

Set frm = Forms("F_Hauptmenü")
Set ctl = frm.Controls("SF_Histogramm Chart")
Set sfrm = ctl.Form

However the Sub form is not refreshed. I know that the data structure has
changed but I still see the old data which have been deleted.

What is the correct setting so that the sub form shows the correct chart?

Hope some one can help me out!

Thanks!

Robert

 

[Robert G]

Forgot one line

Set frm = Forms("F_Hauptmenü")
Set ctl = frm.Controls("SF_Histogramm Chart")
Set sfrm = ctl.Form
sfrm.requery

that is what I have.

Robert