You may well be a neophyte but you can certainly ask a well constructed question. I tend to try and answer questions by concepts rather than by specific coding examples unless the code clearly explains the process.
Since you seem to be rather curious about how the process of development integrates into a functioning product, let me give you a strong suggestion. Macros solve very limited problems, do not allow for error checking, and the more complex they become the harder they are to debug. You have enough grasp of what you want to do to begin moving away from macros and more toward using Visual Basic. Try writing functions to do what your macros do.
There are a lot of people willing to help you develop good coding techniques, but some, like me, shy away from information, advise, or even hints about macros.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com