View Single Post
  #3  
Old November 14th, 2005, 01:43 AM
Joe Cilinceon
external usenet poster
 
Posts: n/a
Default Question about a default table or method

Tom wrote:
You can set a default value for a field in the bottom part of the
table design view and this default value carries throughout the
database everywhere the field is used. You can also set the default
value for a field on a form and this default value will only be
applied on that form. If you set the default value in a table and
want to use a different default value on a particular form, set the
default value also on the form and it will override the table default
value. The table default value will be applied on all other forms.


Thanks for responding Tom but I not quite what I was asking.

I'm looking for a method that will set a var thru a whole program. Now these
var are only used when calculating totals. A couple of examples would be
sales tax that is now 6% but tomorrow could change to 6.5% or a set fee
charge. At the moment I would have to go thru about 20 queries to find and
change these types of things. I would much prefer to either change it in a
table and load on startup or perhaps a module. I'm really not sure the best
way and that is what I'm asking here. Thanks again

--

Joe Cilinceon