I am currently working on creating a visual calculator in an access form. The visual bit being a graph and the interactive bit (or what I would like) being that by moving sliders on a series of sub forms in the main form, which I would like to auto select records as you scroll one way or another.
This would populate fields in the main form which linked by a query re-populates the graph via a setvalue macro, currently activated via the combo box on selection of an entry.
While this works with combo box manual selections, I am having difficuties in establishing a more user freindly sliders set up. Problem im having is getting the auto select bit to work in the sub forms based on usering the slider to scoll one way or the other.
The other annoying prob I have is with the refresh command. While I can manually refresh the graph I'd like the graph to update autoatically without having to press a command button. I have tried adding it as an event procedure on the fields that get updated by making a selection in the combo boxs (on which the query for the chart is based) in the sub forms but this doesnt work. Also tried a macro to do this but i cant get this to work either.
All help appreciated,
Kev