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.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!



"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