Calculating values in a form and storing them

[Nicholas Maryol]

Hello All,

I know that standards of DBase programming are such that
values calculated from a table should not be stored in
the same table. I have a special case where I need to do
this, however (I'll provide details if it helps.) Ergo,
I need to make a form which calculates a value from two
other values from a table and stores the value in that
same table. Is there some way to do this w/o resorting
to VB (ie, use expression builder)? ANY advice (othat
than "Don't do it") would be appreciated.

Nivk Maryol
(e-mail address removed)

 

[Rick Brandt]

Hello All,

I know that standards of DBase programming are such that
values calculated from a table should not be stored in
the same table. I have a special case where I need to do
this, however (I'll provide details if it helps.) Ergo,
I need to make a form which calculates a value from two
other values from a table and stores the value in that
same table. Is there some way to do this w/o resorting
to VB (ie, use expression builder)? ANY advice (othat
than "Don't do it") would be appreciated.

Nivk Maryol
(e-mail address removed)

You need either VBA code or a Macro that will take the calculation result
and "push" it into a bound control on the form so it will be saved with the
record. I would suggest using BeforeUpdate as the event. The bound
control can be hidden if you like.