access vba course - Variable

Hi Debbie

From you question I believe the answer is to declare the variable global.

If however when you say projects, you mean a completely separate piece of code that is run by a different files and is no way linked to the other project I don't think there is a way to make the variable seen by both projects.

Hope this helps

David