Refresh Sub form SHOULD BE SIMPLE : )

[davedinger]

I have a form named Test Master Form it has 2 sub forms on it
The first sub form is Named Test Equipment Form
it has a control on it that when clicked opens a form named Readings. This is a single reecord data entry form that adds data for the information that is contained in the second Subform

The Second sub form is a report and is named test form.
this subform / subreport is a list view of all of the records created by the sub form control in the first subform.

The problem I have is i need to have the second sub form which is a report named test form automatically re query.

I can do it on a timer or on close of the form opened by the first sub form but when I try this its requiring the data in the wrong sub form. its quarrying the data on the Test Master form /Test Equipment form

I need to figure out how to re query the data on the report that is in the Test Master form / test form
not the Test Master form /Test Equipment form.



I think its a simple set focus but im not sure how to set focus on a report in a subform.

Thanks

[June7]

I always name subform/subreport containers different from the objects they hold, like ctrTest.

Something like:

Private Sub Command90_Click()
DoCmd.OpenForm "Readings", , , , acFormAdd, acDialog
Me.ctrTest.Requery
End Sub

[davedinger]

Not sure if we are on the same page, maybe this drawing will help

The forms are
Master Form
with sub form "Equipment" and a Sub Form with the report I need to re-query named "Readings"
and
Reading Single Form
Data entry form probably is not relevant but it is named "Reading Single Form"
The Control "Close" button on the Data Entry form is Control 22.
Thanks

[June7]

Okay, sibling subforms. Code is behind left-hand subform that opens popup form then when popup closes need to requery right-hand subform.

DoCmd.OpenForm "Readings", , , , acFormAdd, acDialog
Me.Parent.ctrReadings.Requery

[CJ_London]

not sure if this works for report sourceobjects, but if it was a form, in the modal form close event

forms!testmaster!form.testform.requery

Where testform is the name of the subform control

Why use are report as a subform anyway? What is the benefit?