Default Value on Form Help



I have a query that calculates the total of a field in my table - Field Name
in my Table is Total Value which calculates the total for a series of records
that has the same invoice number. Field in in my query is Aggregate Value.
I now have a form where I bring in the Aggregate Value. I need to create
another Text box Value Verified where I bring in the Aggregate Value as a
default, but I may have to change it if the Value has changed - but the
Aggregate Value has to remain the same.

I tried using default value on the form for the Value Verified Text control
that brings in the Aggregate Value but it does not work -

does anyone have a suggestion?



Al Campagna

As a general rule, don't save the value of a calculation in a table.
Re-Calculate the value "on the fly" whenever it is needed in any
subsequent form,
query, or report.
For example: Price * Qty = LineTotal
Line Total would not be saved in a table, only Price and Qty. Wherever
Line Total is needed, just recalculate Price * Qty... to get it

The same would hold true for a value derived from adding the value on
several records...
That's the problem with "saving" a calculation. If any of the elements
change, the "saved" value must also be changed. So... just use an unbound
calculated field, calculate on the fly, and avoid that problem.
Al Campagna
Microsoft Access MVP 2007-2009

"Find a job that you love... and you'll never work a day in your life."

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question