Update Sub Form Problem

[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 subform1. 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.

 

[mhong]

I have a very similar problem with you. I use two sendkeys statement to reopen the form.
SendKeys "%VD%"
SendKeys "%VF%"
It work for me but it is very annoy users when they see the form open in design view and then reopen in form view.
I try other method to requery and refresh the subform but it doesnot work.
Help anyone.

 

[Rich]

Have you tried refreshing the form with F9, if that works then Me.Refresh will work.

 

[mhong]

Thank you Rick. But F9 and me.Refresh don't work too.
Please help anyone.

 

[mhong]

Sorry Rich. I misspelt your name.

 

[Rich]

I've had similar problems, I just close and then re-open the form
DoCmd.Close acForm, "YourForm"
DoCmd.OpenForm "YourForm", acNormal, "", "", , acNormal
apart from a slight flicker on the screen which doesn't bother me, it works fine.

 

[mhong]

Hi Rich. I finally choose the same solution with you. In addition, I open one more form while waiting the main form to reload. This form just have a label in it. Then close this form after the main form is complety loaded.
DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "frmIdle"
DoCmd.Restore
DoCmd.OpenForm "frmViewPartInfo"
DoCmd.Close acForm, "frmIdle"
Again, thank you for your help.

 

[jboyle]

Thanks for all the help... I guess I will do the form close and form open statement.

 

[Pat Hartman]

Have you tried requrying the subform?

Me.SubformControlName.Requery