How to combine two docmds to one form

[tmcrouse]

I have a filter and a bit confused how to combine the filter so that it works with 2 forms. Here is my code:

Option Compare Database
Option Explicit

Public Function getgraph()
DoCmd.OpenForm "frmQualityGraph", acFormPivotChart, , GetFilterFromListBoxes
End Function

Private Sub cmdReport_Click()
DoCmd.OpenForm "frmSearchQuality", acNormal, , GetFilterFromListBoxes
getgraph
DoCmd.close acForm, "frmSearchQualityPrograms", acSavePrompt
End Sub

The filter is GetFilterFromListboxes. form SearchQuality displays data from the filter and form QualityGraph is the pivot graph. If I run this, both forms open and update the results fine but if I were to put in a docmd.close acform, "frmQualityGraph", acSavePrompt so that 2nd graph pivot form actually closes, the frmSearchQuality with the embedded PivotChart is displayed but the PivotChart is not updated with results. I have tried to get help with this but the responses confuse me and no one really seems to know how to make this work. I would think something like this should have an easy solution. I have played and played and read and read and to the point now where I think I might just hire someone to figure it out because we are going on 3 wks of trying to make this work.

[ItsMe]

Closing frmSearchQualityPrograms should effect the filter because frmSearchQualityPrograms holds data that no longer needs to be applied to the filter?

[tmcrouse]

I have already tested that theory and whether the frmSearchQualityPrograms is left open or closed, the frmSearchQuality with embedded frmQualityGraph still does not work properly. The graph does appear and it looks nice however the graph does not update the results when embedded. It works fine if I leave 2 separate forms open but that is not how they want it. They want the graph embedded in the frmSearchQuality.

[ItsMe]

It was a question I was asking. I was not trying to test a theory. I just do not know what you are trying to accomplish.

In order to adjust properties such as .Filter, you need to fire some code.

Me.Filter = ""
Me.Filter = "[MyField] = " & MyVariable

Perhaps you can include some code with the Docmd.close line to adjust some properties.

[tmcrouse]

How about the db. I have a filter to grab data from a main form and since it is just too busy to place graphs and have ability to print on this main form, then when the user clisk on view the report/graph button it takes them to that but right now opens 2 separate items. both are correct but I want 1 item to open and the pivot graph embedded.

[June7]

Related/duplicate thread https://www.accessforums.net/access/...art-44006.html