Refesh From Subform

[ckerns]

I have a form with a subform. Sub shows aggregate sums. Also on main
form is a list box to show the details of the aggregate sums.

List box is filtered based on subform and all works well..

If I click on aggregate on subform, click a refresh button on main
form, list will update and show details.

What I want to do is to have the list box refresh when I click on a
control on the subform.

Any ideas?

tia

ck

 

[Guest]

Create something in your main form like:

Sub RefreshForm()
Me.List0.RowSource = ...... 'or whatever your commands are
End Sub

Then in the subform, in the OnClick event, something like

Me.Parent.RefreshForm