Macro to copy and paste

[chr1stoper1]

Hi Guys
I have a problem and am looking for the best way to solve it .In my database I have a form with a drop down box where you select the part number you want the report on. The report is generated and is shown as data plus a graph. I want to put a button on the report that will generate a different type of report if I need to look into a different area of that data like finance.
I don't want to have to use the drop down box again to select the part number is there a way to copy the part number from the report and auto fill the drop down box which will generate the second report?
I hop that makes sence .


Thanks for any help

[CJ_London]

I don't use macros, but in vba you would (or could) pass the part number to the new report via the openargs parameter for docmd.openform and the new report would have code to check if there is a value in openargs and if so populate the dropdown box

Alternative might be to populate the dropdown in the new report by referring to the dropdown control in the original report - e.g.

=reports!originalreportname.dropdowncontrolname

[chr1stoper1]

Yeah I think Ill try the second approach as Im not yet at the point where I can confidently write code.
Thank you for your help