I concur. These types of data are best kept in a table. That also allows use
of a form for the updating of the values very easily.
--

Ken Snell
MS ACCESS MVP



"John Marshall, MVP" wrote in message
...
I would go with tina's suggestion. It places anything that may change over
time in a single location and avoids the problem of using duplicate
information that may get out of sync.

John... Visio MVP


"Joe Cilinceon" wrote in message
...

Actually John I asked for the best method to set default values in an
application, be it as a public variable or Lookup Table. I didn't know
and really still don't know which method will work best for my needs. I
gotten 2 different methods of doing what I want and will try both before
deciding. It really amounts to about 5 or 6 default values, such as sales
tax rate, late fee charges, lock cut fee, admin fee, lien fee and nsf
check fee. I use these charges thru out the application for calculations
and it would be nice not to have to rewrite these values in code every
time they change. I hope that is clearer.

Joe Cilinceon