Refreshing Subforms

[theManLikeWood]

Hi All,

I'm having some trouble keeping all of subforms up to date when I add records in my main form.

I have several subforms inside subforms, spread across several tabs in a tab control on the main form.

One tab is used to add witnesses and on the other tabs you can store other information. Part of this informattion involves storing witnesses and each tab has a subform with a list of witnesses. If I add a witness then all of the combo lists throughout the rest of the form hold the wrong information.

I've tried refreshing when the subforms are 'OnActivate' but am being told that I dont have access to the method. Im not sure if it's because the sub forms are imbedded several times but im not being told the form cannot be found.

Im fairly new to vba so i think i might just be trying the code in the wrong place

Any help is greatly appreciated

Cheers

 

[ejstefl]

What is the code you are using? Depending on how all of your forms, tabs, and subforms are set up, you might want to try refreshing things on the After Insert event of adding a new witness...

 

[RuralGuy]

Here's an excellent reference link if you didn't have it already: Refer to Form and Subform properties and controls