Solving a formula

[JRT]

I would like to store a formula at the record level

i.e. (W/1.5)*L*H


I have three unbound fields that I will declare the values of the three variables.


I need the user to be able to store the formula in simple algebraic terms like above. When a button on the record is clicked, I need to solve the formula based on the values in the unbound fields.


I'm at a complete loss, how do I refer to the value of the expression vs the text string of the formula????


Any help would be appreciated.

Regards

Dave

 

[WayneRyan]

Dave,

The only thing that I can think of is:

Read a record with a formula.

Parse the formula, substituting the values of the
unbound controls in the string.

Then pass the new string off to the Eval function
and get your answer.

Wayne