The following report method works on an old project but not on this one. I am missing a step somewhere. I have a Report Menu Form. I use Popup=Yes on all my forms and modal=NO.
On the Report Menu form, i have 2 unbound combo fields to pick a customer SoldtoID and ShiptoID. I next hit my button which links to a report. Unfortunately, the report output is Hidden behind the menu. i have to exit the menu and my startup form in order to see the report output.
As a test, if i manually input a soldtoID and shiptoID in the plain Access screen (in other words, not using my report menu) for Qry or from Rpt, i see a successful report.
So there is something in my Report Menu Form clogging this up. And i suspect the POPup deal.
FYI: the Qry criteria row has in the SoldtoID field, [Forms]![frmReports]![cboSoldtoID], and the ShiptoID field has [Forms]![frmReports]![cboShiptoID].
on the report Button in the ON Click, I have:
Private Sub ReportLetter712_Click()
DoCmd.OpenReport "rptLetter712", acViewPreview
End Sub
I am baffled.
On the Report Menu form, i have 2 unbound combo fields to pick a customer SoldtoID and ShiptoID. I next hit my button which links to a report. Unfortunately, the report output is Hidden behind the menu. i have to exit the menu and my startup form in order to see the report output.
As a test, if i manually input a soldtoID and shiptoID in the plain Access screen (in other words, not using my report menu) for Qry or from Rpt, i see a successful report.
So there is something in my Report Menu Form clogging this up. And i suspect the POPup deal.
FYI: the Qry criteria row has in the SoldtoID field, [Forms]![frmReports]![cboSoldtoID], and the ShiptoID field has [Forms]![frmReports]![cboShiptoID].
on the report Button in the ON Click, I have:
Private Sub ReportLetter712_Click()
DoCmd.OpenReport "rptLetter712", acViewPreview
End Sub
I am baffled.
