Updating Report based upon Updated Form

[kelann]

I have a form (TrackSelectEventF)
that opens a report (TrackEventRep)
based upon an EventProcedure in a combo box:

Private Sub OpenTrackEventRep_Click()
DoCmd.OpenReport "TrackEventRep", acViewReport, , "RespEventName = '" & Me.TrackSelectEvent & "'"
DoCmd.Close acForm, "TrackSelectEventF", acSaveNo
End Sub

The opened report (TrackEventRep) lists organizations in the detail part
with a button (ButtonUpdateStatus) beside each organization
that opens a form (TrackUpdateStatusF), allowing people to update the status of that organization.

When the TrackUpdateStatusF is saved, the TrackEventRep is not automatically updated, which makes reasonable sense. When the report is closed and reopened via the steps at the beginning, it is, of course, updated with the most current data.



Is there any way for this to happen when the TrakUpdateStatusF is saved? Some SQL behind the Save button on the TrackEventStatusF perhaps?

My current workaround is to have the TrackEventRep close when the ButtonUpdateStatus is pressed, but to update the status of another organization, they must go back to "square 1."

Thanks for any thoughts!

--ak

[June7]

AFAIK, once a report is rendered, its dataset cannot be altered. Must close and reopen. Test this with the Refresh button on the ribbon.

[kelann]

Thanks, June! Much appreciated, as always!

[June7]

Additional note, the dataset of open report (in Report or Layout views) can be filtered. This does not change the report's dataset, just applies a filter to the set.

[kelann]

Thanks, June!

I made it happen by creating an event procedure liinked to the save button -- it now saves, closes the form, and opens the report, which now has the updates!!!!