query and report

[makisbest]

Hi there

I have a report ready connected with a Query.
I make a copy of that report and I want to connect it
with a diferent Query how I can do that.

I am using Access 2003

Thank you

 

[Tash]

In your Copy of the Report, go to the Report's Properties in Design view. Under Record Source, change the name of the Query that you want to assign to it.

 

[ZmrAbdulla]

Do you need it changing always? or once?
If it is once then change the RecordSouce of the query and the controlsouce of textboxes etc.

If you need it any time you need then you have to do it by VBA.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Even a thief takes ten years to learn his trade.