requery repaint or what?

[Ivor Williams]

I have a form with two subforms, all linked on ProjNo, all use as a record
source queries (not the same one). After updating a value in the first
subform, I would like to have the values in the second subform update
without having to close and re-open the main form. I'm not sure whether I
should use requery, repaint or what and what is the proper syntax to refer
to the second subform in VBA.

Ivor

 

[Barry Gilbert]

In the first subform, try something like this:

Me.Parent.2ndSubFormName.Form.Requery