Global variables? Please help me

[littlenicky]

How do I make global variables? I have a settings table, which holds some basic information, which I need in almost every form I got. So how can I access this information from each form? I'm using usually other tables as a source of the form for the form needs, so I can't set this one as the source in these forms...

 

[Mile-O]

In a module - place the variable:

i.e

Public strUsername As String

If it's going to be the same thing throughout the whole database, maybe a constant, rather than a variable, would be better:

i.e.

Public Const strVersion = "v1.00.01"

Out of interest, what sort of things are in your settings table? Is this a preferences list for each user?

 

[littlenicky]

Thanks for help!

I'm doing a Video Library project, and in settings I hold: Maximum Days for rent (New and old movies), and Fine per one day.