report based on a changing query

[dott]

I have a report made which is all laid out how i wish it to be. But i want to change the query of the report to something new based on a users input in a form. I know how to create the new query, but i do not know how to apply that new query to my old report. Is this possible?


Sorry I will try posting this in the correct forum.

 

[mission2java_78]

I have a report made which is all laid out how i wish it to be. But i want to change the query of the report to something new based on a users input in a form. I know how to create the new query, but i do not know how to apply that new query to my old report. Is this possible?


Sorry I will try posting this in the correct forum.

Yep possible...in fact I do this quite often. i always have a need for the same report but a different query behind the scenes.

To do this in the on open event of the report do the following:

Me.Recordsource="thequeryyouwant"