How to declare a global variable

[KentMorand]

I know this is an easy one but I've been out of the game for a while and need a little help. When a user chooses a team from a list box on the first form I want that value to be saved (presumably as a global variable) so it can be used in every other form in the database. Currently I am basing forms on queries and passing the value of the list box into the query but this seems kind of messy. Any help would be appreciated.

 

[Norris68]

Create a code module. Type Public VariableName As , then type/select your base type. Save you code module, calling it something like 'Public Variables'.

e.g.
Public MyString As String

Be aware though, that if your code breaks in any unhandled errors and you have to reset you will lose the values of your variables.