Output report help please - I'm very confused

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've searched through these messages for direction and I'm confused as ever.

I have a report that calls up a form with an event procedure. The form
provides the criteria to the queries/subreports -- store #, fiscal period,
fiscal year. What I want to do is programmatically output the report in snp
by store # having the code loop through the stores *but* request the period
and year once and have that apply to all stores. (That is, a separate report
for each store.)

I'm guessing the code can be written to effectively ignore the form, but I
haven't a clue how to start.

Any pointers are appreciated. Thanks.

Allan

BTW Access 2003, Windows XP
 
I have a report that calls up a form with an event procedure. ....
What I want to do is programmatically output the
report in snp by store # having the code loop through the stores *but*
request the period and year once and have that apply to all stores.
(That is, a separate report for each store.)
Click to expand...

My guess is that it would be easier to have the form open the reports; this
sounds like a For... Next loop or else a Do While Not rs.EOF...Loop loop.

HTH

Tim F
 
Thanks for the direction, Tim. I wasn't thinking along those lines since I
got my original code from this forum!

So once I change this around, having the form run the report, I guess it
would be possible to have two command buttons -- one to preview a report by
store (based on the combo box parameter) as is the case now, and another to
output all stores?

Thanks for your help. Allan
 
one to preview a report by
store (based on the combo box parameter) as is the case now, and
another to output all stores?
Click to expand...

.... or one checkbox to switch preview on & off, and one command button to
do it. Whatever floats your (or your users') boat. <g>

B Wishes


Tim F
 
Back
Top