G
Guest
I have built my first database which I use at work to provide numerous
different reports giving stockloss details for 350 of my shops. I have about
36 reports that I am able to run off giving details at individual store or
district level. Each one of these reports has a parameter query as its
source, which normally asks me to enter the year and month for the data I
want.
Each month I have to print a pack that contains about 25 of these reports. I
have created a macro that does this but I have to enter the same year and
month every time each report is going to be printed.
Can someone point me in the right direction to negate the need to enter the
same information every time these reports are printed. Ideally I would Like
to produce a form that has a couple of combo boxes on it.
1) For the Year
2) For the Month
The user could select the chosen combination click a button and the reports
would print off.
Thanks
different reports giving stockloss details for 350 of my shops. I have about
36 reports that I am able to run off giving details at individual store or
district level. Each one of these reports has a parameter query as its
source, which normally asks me to enter the year and month for the data I
want.
Each month I have to print a pack that contains about 25 of these reports. I
have created a macro that does this but I have to enter the same year and
month every time each report is going to be printed.
Can someone point me in the right direction to negate the need to enter the
same information every time these reports are printed. Ideally I would Like
to produce a form that has a couple of combo boxes on it.
1) For the Year
2) For the Month
The user could select the chosen combination click a button and the reports
would print off.
Thanks