Global Variables?

[futurezach]

Hi all,

I am creating a report that is basically a set of different queries displayed on one page. Most of these queries require a start date and end date to be entered before it spits out the statistics. The only problem is that because I have 8-10 queries, I have it asking for a start date and end date 8-10 times. Is there a way to create a kind of "global variable" that all I need to do is enter it once and this copies the value over to all queries? Apologies if this is a dumb question but I am relatively new to access (i'm using 2003), and all the books make no mention of this functionality.

Thanks!

[amrut]

You can declare say StartDate and EndDate as global variables. In the queries, use these variables as criteria. Always remember to assign them values before these queries are called.Other option is use a form which is always open or a hidden form and populate two text boxes on this form with the date ranges you need.

[futurezach]

Okay, but how do I declare global variables?

[RuralGuy]

Are you *always* running these reports from a form? If so then the queries can reference controls on that form rather than using Global Variables.

[RuralGuy]

FYI: Global Variables are simply Public variables declared in a Standard Module rather than in a code module for a form.