Open a report based on different queries

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

Guest

I have a fairly simple database with only one main table for data. I have
three basic reports. Right now I have about 25 different reports based on
each basic report, the only difference is that they each either have a
different query as the record source, or that they are sorted differently.

The problem with this approach is that when someone decides to make a
stylistic change to the report or to add or delete fields, instead of making
one change I have to make the change 25 different times. I usually just copy
and paste, but it does take time.

I need to do this with command buttons on a form somehow. I don't know
progragamming although I have been using Access since about 1992, only
creating relatively simple databases.

I would like a SIMPLE way to be able to run the same report based on what
the end user wants to see. Basically I guess this would be a command button
that has some sort of macro that would open the report based on what the end
user wants.

I'm using Access 2002. Hope this is clear enough! Thanks in advance.
 
Not really replying, just adding to the question: I have a similar situation,
where the report in question is just an envelope(s). In some cases I want to
print a single envelope with the address of the currently displayed record;
that's easy enough to do in a macro with the Where condition on the
OpenReport action (from a form where the proper record is already displayed).
But in another form I do a parameter query to find specific addresses based
on data in another table, and want to print envelopes for all the matching
records -- how can I use the Where condition to set that, without rerunning
the query, which seems a waste of effort? Or do I have to change the
RecordSource for the report in this case? Or do I really need to have more
than one generic envelope report???

Thanks in advance for both of us... -Ann
 
Back
Top