Status Bar

[Guest]

I found some code that allows me to do AutoSum in a form in access. the Code
works fine. It allows me to click in various fields and it places the total
in the Status bar. My question is how can I get the total from the status
bar into a Record on the form without doing it manually. Is there a way to
use code to copy the information in the status bar to a record of choice.

Sandrao

 

[Marshall Barton]

I found some code that allows me to do AutoSum in a form in access. the Code
works fine. It allows me to click in various fields and it places the total
in the Status bar. My question is how can I get the total from the status
bar into a Record on the form without doing it manually. Is there a way to
use code to copy the information in the status bar to a record of choice.

No. When you place the value in the status bar, put the
same value in a text box bound to the record source field.

Are you sure you want to violate the rules of normalization
by saving a calculated value? Maybe you do, if the
calculation can not be done using normal operations.