How to automatically requery subreport listbox from another form

[Paul1]

Please find attached my example db.



I would appreciate some help with requerying my subreport listbox from an action in another form.

For example if you click on the top row list box REP197 then the “Scheduled Details” listbox on the subform is populated. If you then double click one of those rows, the “Edit Scheduled Details” pop- up form is displayed where you can edit the details in this subreport.

Now for example if I select a different frequency, requestor or format and then save the form, any changes are not shown until I click the row again in the “Scheduled Reports” listbox on the top.

I have tried so far unsuccessfully to automate this and would appreciate if someone could suggest how this listbox row could be automatically clicked on when saving and closing the popup form.

Many thanks for all your help.

[davegri]

For form frmEditScheduledDetails:

Option Compare Database
Option Explicit
Private Sub cmdSaveClose_Click()
   DoCmd.Close acForm, Me.Name
   Form_frmScheduledReports.Refresh
End Sub

[Paul1]

Yes this works perfectly.


I did try exactly the same thing with .requery
Why doesn't .requery also work in this scenario?


Many thanks.

[davegri]

Why doesn't .requery also work in this scenario?

I don't know and from Googling, the explanations there don't seem to fit your scenario.
I code for empirical results desired, (read trial-and-error ) not so much by predicting esoteric Access behavior.

[Paul1]

OK fair enough. Thanks again for all your help.