Code for activating another report filtered by the original report

[tuniwes]

Hi Guys

First post here, I'm struggling with how to dynamically pull up another report based on double clicking a field in the first report



I have a report...."shipping" that has an Item number as one of the fields. What I want to do is launch a second report "Factory WIP" filtered by the Item number that was double clicked on.

I know this has probably been covered somewhere before, I have a great generic database that is mostly covered by "right click" contains but this would be the "icing on the cake"

Any help please would be most appreciated.....I have a dim and fond back ground in the DOS world of Dbase4(I swear it is still quicker for some things) but have to admit that VBA code is baffling to me

Thanks in advance

Ian

[June7]

The report would have to be in ReportView, not PrintPreview. PrintPreview is not interactive.

Code in report DblClick event would work. However, clicking on textboxes in group/report header/footer sections will not work, must click on rows in the Detail section.
Or the textbox DblClick event.

DoCmd.OpenReport "Factory WIP", , , "Item=" & Me.Item

[tuniwes]

The report would have to be in ReportView, not PrintPreview. PrintPreview is not interactive.

Code in report DblClick event would work. However, clicking on textboxes in group/report header/footer sections will not work, must click on rows in the Detail section.
Or the textbox DblClick event.

DoCmd.OpenReport "Factory WIP", , , "Item=" & Me.Item

Thanks for your reply, when I tried the code as soon as I double clicked the item it started to print the wip report rather than open it normal report view.

how can I remedy this please

Thanks for your help