update subform

[shelspa]

This may have been covered but I didn't find it. I want my subform to update when data is entered on the main form. The data displayed on both is from the same table. The subform happens to be a chart. Of course, charts use a query. These details are probably what is complicating it. Ideas?

 

[WildHare]

Issue the refresh method on the subform, whenever you want it to re-read the data. I don't know which event on your main form you'll want to use.

Sub Form_Change()
me!{subform-control}.FORM.Refresh
End Sub

I think that's the syntax... 78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[shelspa]

So in the after update event of one of the fields on the main form I could do this:

Sub Form_Change()
me!{chtNordikoThickness}.FORM.Refresh
End Sub


..or put this somewhere else? Correct syntax? thanks

 

[WildHare]

I think that should work - just remember to reference the control-name, not the subform name itself.

78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm