S
steveH
I have a form that does a number of calculations based on various field
values. I am currently doing the calculations in VB because some of the
input values need to change based on user input. For instance speed.
OnCurrent I set the speed based on the range returned by the query. And then
I created a pair of increase/decrease commands that change that speed. The
balance of the calculations use that value and the values from the query. I
could stick everything into the query but I can't figure out how to update
the speed value and still have my OnCurrent condition. The thing works as it
is with VB but I would like to add a graph to the form (actually the parent
form) but all my calculated values are unbound.
I thought maybe I could update a separate table as a record set in vb to use
as the graph source but that seems too much.
values. I am currently doing the calculations in VB because some of the
input values need to change based on user input. For instance speed.
OnCurrent I set the speed based on the range returned by the query. And then
I created a pair of increase/decrease commands that change that speed. The
balance of the calculations use that value and the values from the query. I
could stick everything into the query but I can't figure out how to update
the speed value and still have my OnCurrent condition. The thing works as it
is with VB but I would like to add a graph to the form (actually the parent
form) but all my calculated values are unbound.
I thought maybe I could update a separate table as a record set in vb to use
as the graph source but that seems too much.