Thanks that I kind of knew.

Duane Hookom wrote:
This is data. Data is stored in tables. Use functions and/or code to
define default values in text boxes on forms.

--
Duane Hookom
MS Access MVP

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

--

Joe Cilinceon