Report opens in wrong view from switchboard

[puddy tat]

Access 2007 does this weird thing where my reports are opening in a
different view than I've selected as the default view from my
switchboard menu. If i select and run the report from the navigation
pane, the report opens in the default view as specified in properties.
However, if a button is clicked on the switchboard it will open the
report seemingly according to its own set of rules which seem to have
nothing to do with the default view specified.

 

[Jeanette Cunningham]

post the code that opens the report from the switchboard.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

If you use this code, you can get the report to open in preview view in
A2007.

DoCmd.OpenReport "[NameOfReport]", View:=acViewPreview

Note: use your report name in place of [NameOfReport], you only need the
square brackets if there are spaces in your report name.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia