Hello all,
I am sure there is a really simple answer to this but i have been having a heck of a time finding what im looking for by searching so hopefully someone here can help.
I have a chart on a form that runs a query. It works fine except I want to allow the user to enter a date from and date to on that screen, hit the 'go' button and update the chart with those date ranges.
My question is how do i tie those date textboxes to the criteria of my query when the user hits the update button?
Or even, how can i change the charts query on the fly through vba?
Thanks for any help!