Quote:
Originally Posted by jl2886
I am just beginning to learn access for my job. I have created a table that contains certain variables and then created a form for those variables. I want some of the variables to be dependent on other variables. For example, here are three variables: Premium, FaceAmount, PremPerFaceA
Premium and FaceAmount need to be input, but PremPerFaceA=Premium/FaceAmount.
On the form I input the formula in the control source and it works. The variable in the table, however, does not get input. When I tried to put the formula in the default value of the table variable of the PremPerFaceA, the list of variables in the table did not show up in the expression builder. The variables only come up in the expression builder when I am in form.
As a side note, I do not know visual basic. Would it be better for me to do all of this using visual basic, providing I can learn it in approximately a week.
Thanks
For a lot of reasons some of which you've outlined calculated values are not stored in the table. What would happen if there was a change to either the Premium or FaceAmount value. Calculated values like this are normally just calculated as required.
Mary
