Just curious about using 'Public' to define variables. Is there a 'more
correct' place to list variables that you want used by all modules in a
project? Module 1? Form Code module (if you are using a menu)? Completely
separate module?

Also curious about how VBA works here. Does it read through all modules
when you open a project and pull the 'Public' variables? Or do you have to
use code in a particular module before it picks up any variables listed in
that module?

--
Bill @ UAMS