Visual Basic Code , VB.NET Code, VB Code
  Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact


confused on how to use open args


confused on how to use open args

Author
Message
cuddles
cuddles
Forum God
Forum God (415 reputation)Forum God (415 reputation)Forum God (415 reputation)Forum God (415 reputation)Forum God (415 reputation)Forum God (415 reputation)Forum God (415 reputation)Forum God (415 reputation)Forum God (415 reputation)

Group: Forum Members
Posts: 1, Visits: 6
I have a form with listboxes. The end-user selects what they want and then can click a button to show their results in a continuous form. Because there are many listboxes and the continuous form is just too busy, I created another button for the user to select when they want to get to another form that has a subform pivot chart. When they click the button, it is supposed to take the filter and feed it to the form and subform pivot chart. If I create the following code:





Private Sub cmdResults_Click()

DoCmd.OpenForm "frmSearch", acNormal,, GetFilter

DoCmd.OpenForm "frmGraph", acFormPivotChart,, GetFilters

End Sub





Both forms are update properly and both open in their own tab. The issue is, I embedded the pivotchart into the frmSearch and the frmSearch shows the results correctly but the pivotchart does not update. Now, this does not have to be forms. I can do a report called rptSearch and then embed the form frmGraph. Does not matter. Just not sure how to code the open args to apply the filter........GetFilter to each item but have it do it when the item is embedded.
GO


Similar Topics


Reading This Topic


Login
Existing Account
Email Address:


Password:


Social Logins

Select a Forum....

















A1VBCode Forums


Search