I have attached a sample database for you to hopefully assist me with my quandry. Basically my code in my [cmdRun] button on [frmTest] works with [qryComparison] but my query only refreshes when I close the query and open it again not on click or via the refresh button.
The subform on [frmTest] should also refresh itself after the [cmdRun] has been executed. I have two expression fields in my query that are controlled by the two combo boxes of my [frmTest] when the [cmdRun] button is pressed.
I am trying to create a comparison form which looks at data increases by percentage + amount, depenmding on the month parameters set by the user via the form. Your assistance is much appreciated.