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

"puddy tat" <puddytat94@gmail.com> wrote in message 
news:f90870d0-2a46-4392-863b-3255e5769406@k5g2000pra.googlegroups.com...
> 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. 

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


"Jeanette Cunningham" <nnn@discussions.microsoft.com> wrote in message 
news:ONXvo6SpKHA.5588@TK2MSFTNGP02.phx.gbl...
> post the code that opens the report from the switchboard.
>
>
> Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
>
> "puddy tat" <puddytat94@gmail.com> wrote in message 
> news:f90870d0-2a46-4392-863b-3255e5769406@k5g2000pra.googlegroups.com...
>> 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.
>
>