change of one variable changes another

  • Thread starter Thread starter Greg Green
  • Start date Start date
G

Greg Green

Access XP, MDB/MDE
I have a global in a module. When it changes, I'd like that to change
another global variable that is within the same module. Being that there
isn't an event model around the first variable, I don't see how to trigger
the change of the second variable. Any ideas? TIA
 
Use a custom class with public properties in place of the global variables.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Greg said:
Access XP, MDB/MDE
I have a global in a module. When it changes, I'd like that to change
another global variable that is within the same module. Being that there
isn't an event model around the first variable, I don't see how to trigger
the change of the second variable.
Click to expand...


Your code that sets the first variable can also set the
other variable.

If you want to hide the dependency, use a Sub procedure to
set both variables.

If your question is just the tip of an iceburg of larger
dependencies, consider using a Class module with the
variables as properties. This would probably be better than
using global variables anyway.
 
Back
Top