Report Question

[jukus]

I have a report that comes from the fields in a form. I created a query which allows me to pull only certain records with in a date range. I then created a form based on the query so I could then create a report for the dates I used. Is there a way to take an existing report and change which form the text boxes are populated from.

Ex. Report 1 pulls item from frmWorkOrder. I now have a form DateofWorkOrders (based on query). I want to take Report 1 and populate the textboxes from DateofWorkOrders and then save it as a new report.

I would hate to have to start all over on my report design if there is a way to change it to get the text from a different form.

Thanks!

 

[ted.martin]

Have your tried copying and pasting the Report and then just changing the new reports Control Source property?

 

[jukus]

Thanks, changing the contro source worked great. Took me a second to find it but I did. Appreciate the help.