Thanks again I will check it out.

PC Datasheet wrote:
Joe,

Look at TableDefs and Fields collection in the Help file. You need
code that gets to something like this:
Db.TableDefs("MyTable")!Fields("SalesTax").Default Value = .065

This might not be totally the correct syntax but it gives you the
idea of what to look for in the Help file.



"Joe Cilinceon" wrote in message
...
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

--

Joe Cilinceon