Re: How can I get "CONSTANT" behavior from a variable (Constant magic)?

The only thing that comes to mind would be to have a utility table that you
write this value to when your app opens, then either refer to it directly
each time you need it, or, if you are a good do-bee and have error handling
routines on all procedures, re-assign it to a global variable if an error is
encountered.

I use such a table for holding things like company addresses, phones numbers,
fax numbers, etc, that are used in printouts. That way, if any of these
things change, the end user can change the information, which wouldn't be
possible if it
were hardwired. You can also use it to store information about the last
record that was worked on, so that the user can pick up where they left off.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

.

Relevant Pages