Requery the subform

[jboyle]

I have a main form with two subforms. Non of the forms are bound. On subform1, I have a list of items with a check box. If the user selects check marks on various items, I want the subform2 to display the items selected in sugform1. If I close the form and reopen the form, then the selected items are displayed just as I wanted them to be. Is there a way to requery, refresh or something so I don't need to close and re-open the form to display the selected items?
Thanks in advance for your help.
P.S. Does anybody know what happend to Angello? He has been very helpful and I have not heard or seen him post since 9/11/01. I hope everything is ok with him.

 

[crosmill]

You might be able to make a macro that Repaints the subform, if this works then set the afterupdate() properties of the check boxes to run the macro.

 

[jboyle]

The re-paint didn't seem to work. Does anybody else have any ideas?

 

[John.Woody]

If you only want the second subform to display information you could display it in a list box and then refresh it after updating subform one.

HTH

 

[Jack Cowley]

In the After Update event of one of the check boxes on Subform1 try this:

[Forms]![MainForm]![Subform2].requery