Opening reports from a control source subform

[GraemeG]

Hello

I am having trouble opening a report from a command within a subform.

I have a main form with a control source in which a navigation panel no the main form dictates what opens in the control source i.e. subforms.
This all works great but one action I require is within this control source is a subform with a command button to open a report. But it wont open. However it will open when I just view that subform as a form and not in the control source.

Any ideas much appreciated thanks.

[June7]

Show the code for opening the report.

[GraemeG]

Private Sub cmdKitchenTotalForecast_Click()
    DoCmd.OpenReport "Rep_Kitchens_CostProfile", acViewReport, , , acWindowNormal
End Sub

[GraemeG]

Resolved. I needed to make the report a popup.
Thanks for your help anyhow.