I'm having an issue with no matter what I do, my report keeps opening in print preview and I want it to open in report view. I'm using Access 2007 on XPSP3.
This is what I have done:
In the property sheet I've set - Default View = Report View, All Report View = Yes
I created the following event:
Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenReport "Report_SCS Database Query", acViewReport
I'm not an Access guru, any help would be appreciated.