Text Box on form contains calculation

F

fluffy

The following calculation is contained in the default value property of a
text box. The result of the calculation is not displaying in the form - why
not?

"=([Customer/Supplier Satisfaction System]![Quantity])*([Customer/Supplier
Satisfaction System]![RGA Cost])"
 
R

Rick B

If it is the DEFAULT, then those other two controls would need to have
entries when you start a new record. Most likely, when you start a new
record, those other two controls will be blank. Therefore your default will
be blank.
 
F

fluffy

Even when there are entries in the 2 fields it still shows up as zero
dollars. I tried it earlier with the quantity * rga cost in the control
source field and got an answer in the right box, but it wouldn't update the
database. When I put it in the default value section, I get nothing. Any
ideas?

Rick B said:
If it is the DEFAULT, then those other two controls would need to have
entries when you start a new record. Most likely, when you start a new
record, those other two controls will be blank. Therefore your default will
be blank.

--
Rick B



fluffy said:
The following calculation is contained in the default value property of a
text box. The result of the calculation is not displaying in the form - why
not?

"=([Customer/Supplier Satisfaction System]![Quantity])*([Customer/Supplier
Satisfaction System]![RGA Cost])"
Click to expand...
Click to expand...
 
R

Rick B

Would not update the database? You don't store a calculation back to the
table. That would be redundant. You store the values that make up the
calculation, then perform the calculation in your forms, queries, or
reports.

Even when there are entries in the 2 fields...? How can there be entries in
the 2 fields when you START ADDING A NEW RECORD? That is the only time that
a "default" value will be used. If you have values in the other controls,
then you are past the "default" part.


--
Rick B



fluffy said:
Even when there are entries in the 2 fields it still shows up as zero
dollars. I tried it earlier with the quantity * rga cost in the control
source field and got an answer in the right box, but it wouldn't update the
database. When I put it in the default value section, I get nothing. Any
ideas?

Rick B said:
If it is the DEFAULT, then those other two controls would need to have
entries when you start a new record. Most likely, when you start a new
record, those other two controls will be blank. Therefore your default will
be blank.

--
Rick B



fluffy said:
The following calculation is contained in the default value property of a
text box. The result of the calculation is not displaying in the
Click to expand...
form -
why
not?

"=([Customer/Supplier Satisfaction System]![Quantity])*([Customer/Supplier
Satisfaction System]![RGA Cost])"
Click to expand...
Click to expand...
Click to expand...
 
Top