Refresh SubForm (easy)

[Bryan]

I have two subForms on one main form. How do I refresh all
three forms from one of the sub forms, any event will work,
I may use on lost focus. Each time I try something Access
tells me the form is not open???

 

[John Vinson]

I have two subForms on one main form. How do I refresh all
three forms from one of the sub forms, any event will work,
I may use on lost focus. Each time I try something Access
tells me the form is not open???

A Subform is NOT "open" in its own right. It's not part of the Forms
collection.

To refresh a Subform, you need to refresh via the main form,
referencing it by the Name property *of the Subform control which
contains the form* - note that this will often be the same as the name
of the form within that control, but not necessarily!

Forms!mainform!subformcontrol.Form.Refresh

should do it, given the actual names of your main form and subform
control.