Hi all,
I just joined 'the scripts' after a year of using it as a great resource, mostly for Python. However, I've been beating my head in for a while now trying to find a solution for a problem I'm having in Access 2003. I was hoping someone could help me out with this.
I'm trying to use two sliders to define the upper and lower range for data displayed on an unbound MS8 graph in my form. The form initially shows a graph of the entire data set, which has a query as the record source. I have two slider controls (microsoft slider control 6.0 (SP4))under the graph, one which defines the lower limit, and the other as the upper limit. When the sliders are adjusted, I want the graph to display ONLY the selected region, in real time. Once the relevent data is selected, it gets stored in a separate table.
The problem I'm having is that I've been trying to tie the value of the slider to the query, but it doesn't automatically refresh the chart data, and even when I set up a repaint or requery macro in the ON UPDATED property, I still can't get it to work. I'm guessing there is probably a better way to do this using the coding window. Any suggestions would be greatly appreciated. Thanks