Refresh a subsubform after an entry is made in another subsubform

[flofoo]

Hi... I see a lot of discussions about refreshing or requerying main forms and subforms in the forum but haven't found one about subsubforms. In my main form I have a subform with several tabs that contains subsubforms linked to the subform. After I enter a record in subsubform1, I have a VBA code written to insert some of the fields in subsubform1 to a table that subsubform2 is based on. The problem I am facing is I would have to click on the next record and come back to see the entry made to subsubform2. Please help!

 

[Brian1960]

Try something like this in the onUpdate Event
Forms(frmMainFormName).Form(frmSUBFormName).requery

 

[flofoo]

Thanks for the reply but unfortunately it didn't work! Any other ideas?

 

[RuralGuy]

Try:
Forms!MainFormName!SubFormControl.Form!SubSubFormControl.Requery

 

[flofoo]

I guess I am a little confused.

I should replace the MainFormName with my parent form name and the SubSubFromControl with the field I am trying to requery After Update. But what should I replace SubFormControl with?

 

[RuralGuy]

Forms are displayed on other form by means of a SubFormControl. It is the name of the SubFormControl that is needed. This is often the same as the SubForm but it is *not* a requirement. In your case you will be using two SubFormControl names, one nested within the other. Just for the record, you Requery forms and not fields.

 

[flofoo]

Thanks for the clarification!!! I tried it and it worked.... Yeah! Really appreciate your help in this.

 

[RuralGuy]

Glad I could help. Your question is asked here often so don't feel alone.