Report opens in wrong view from switchboard

  • Thread starter Thread starter puddy tat
  • Start date Start date
P

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.
 
post the code that opens the report from the switchboard.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
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
 
Back
Top