I want my line chart, based on a combo box linked to query, to refresh when I click a button. I have tried a number of different codes that I've found through Googling the issue but none are working to refresh the line chart. I tried the built in refresh button and the codes similar to the below for an On Click event procedure:
[Forms]![frmVWPChart]![Chart54].Refresh
[Forms]![frmVWPChart]![Combo46].Refresh
[Forms]![frmVWPChart]![Combo46].Requery
[Forms]![frmVWPChart].Refresh
[Forms]![frmVWPChart].Requery
Me.Refresh
Me.Requery
Nothing happens when I click when using any of those but it does update when clicking 'Refresh All' on the Home toolbar.