Requery a subsub form

[speakers_86]

In the on close event of a form, I would like to requery a subsub form. How can I do that?

 

[John Big Booty]

Are you wanting to Requery the subform of the form being closed? Or the subform on another form?

If it is the first option, to what end do you wish to requery the subform given the main form is being closed?

 

[boblarson]

A couple of ways:

Forms!YourMainFormNameHere.YourSubformControlNameHere.Form.YourSecondSubformControlNameHere.Form.Requery

or

Forms("MainFormNameHere").Controls("FirstSubformControlName").Form.Controls("SecondSubformControlName").Form.Requery

 

[speakers_86]

Thank you guys.

The first one is what I had. The second one is what bob told me to do and it works.

[Forms].[frmhome].[subHomeSchedulesForm].[Form].[subHomeSchedules].[Form].Requery
Forms!frmhome.subHomeSchedulesForm.Form.subHomeSchedules.Form.Requery

Its the little things.

 

[boblarson]

Thank you guys.

The first one is what I had. The second one is what bob told me to do and it works.

[Forms].[frmhome].[subHomeSchedulesForm].[Form].[subHomeSchedules].[Form].Requery
Forms!frmhome.subHomeSchedulesForm.Form.subHomeSchedules.Form.Requery

Its the little things.

You might also check out my small tutorial on subform syntax here on my website.

 

[speakers_86]

Thank you bob.