I have VBA code on forms and VBA code in modules - how do I make a variable
that they can both access? (Or how do I pass infomation between the two?)

I want to have a module that has an open database function that I can reuse
on different forms. (i.e save me copy pasting database open each time) and
then return a variable - I can do this in c++, how do I do it in VBA?

Many thanks in advance

--
Thanks

Parkin_m