Actually, I comprehend almost nothing of this post :) I wouldn't even know what background information to start reading in order to make sense of it!
I'll stick with declaring db = CurrentDB when the program loads to set my global variable based on your final remark, even though you said that...