Possible to connect a single report to multiple queries?

[ghadley_00]

Hi,

I have an MS access database where table entries are each assigned to 1
of multiple users. I also have the same report that shows summary data
about each user's entries as a single report. (So for X users I have to
maintain X different reports, that are are identical except for the
data source, which are X predefined queries).

1) Is there a way for me to maintain a single reports, and have the
datasource defined via a button event? (i.e. via VBA?) So on clicking a
button I could have the same report open with it's data source being
different predefined queries?

Thanks,

George Hadley
(e-mail address removed)

 

[Douglas J. Steele]

Sure. All you need to do is change the report's RecordSource property.

However, do you really need X predefined queries? Can you not simply use 1
query with a parameter for which user?

 

[ghadley_00]

Thank you for the response.

1) any suggestions on how to set the recordsource property as part of
the form open button?

2) how does one define a custom query for this recordsource property?

Thanks,

George

 

[Kay]

Hi

Create a query from the query tab and save it. Then on the forms record
source property it will give you an option to use that query