Print preview

[Mukhmoor]

I have a report tht accepts date as input parameter. Default view of report is set to print view. I m using a switchboard to open the report but it always opens the report in report view and when i change report to print view at runtime, it asks for the input parameter again. I change the switch board macro as well and changed the argument of openreport to printview but still its not working. Can someone help? Thnx

 

[JamesMcS]

Don't know why the macro isn't work as I've not used them for that before - have you tried using VBA instead? As in

docmd.openreport "Report Name", acviewpreview

In the button's on click event

 

[Mukhmoor]

Thnx....this works fine in VBA but i need this to work with switchboard. Is there anyway to avoid asking input parameter again when switching between different report views?

 

[JamesMcS]

I think it requeries the query when you switch views - so probably not. What I'd do there is turn the query the report is based on into a make table, then base your report on that. That way the table will be built based on the parameters that are entered just the once, then the report will be based on the table.