Hi All,
There is probably a very simple solution to this, but after a couple of hours of experimenting and google search, I can't find it.
When I open my DB in design mode, i.e. pressing the "Shift" key, I have no problems. The form opens ok and the report opens correctly from the CMD button - see picture 1.
However, when I run the DB as I want the user to do, then the report opens only as the title bar - see picture 2
It's basic code to open the report
DoCmd.OpenReport "rptQCWeeklyReport", acViewReport, , , acWindowNormal
There is probably a very simple solution to this, but after a couple of hours of experimenting and google search, I can't find it.
When I open my DB in design mode, i.e. pressing the "Shift" key, I have no problems. The form opens ok and the report opens correctly from the CMD button - see picture 1.
However, when I run the DB as I want the user to do, then the report opens only as the title bar - see picture 2
It's basic code to open the report
DoCmd.OpenReport "rptQCWeeklyReport", acViewReport, , , acWindowNormal