A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Default Value on Form Help



 
 
Thread Tools Display Modes
  #1  
Old April 30th, 2010, 04:02 PM posted to microsoft.public.access.forms
Mariela
external usenet poster
 
Posts: 14
Default 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?
--
Regards - MD
  #2  
Old April 30th, 2010, 04:54 PM posted to microsoft.public.access.forms
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Default Value on Form Help

Mariela,
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...

but I may have to change it if the Value has changed

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.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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


"Mariela" wrote in message
...
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?
--
Regards - MD



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:13 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.