Display Report in a form??

[bddewell408]

I have an unbound form with several command buttons and subforms that I have hidden visibilty unless you click their command button, that way multiple screens do not open. Keeping with that train of thought, I would like to be able to preview a report in an unbound or bound object frame, or however I have to do it, because what I have tried so far has not worked. I cheated so far by making a subform look very similar to the report, and then have a command button that prints the real report without ever letting the user preview the real report.

My question is, how can you preview a report in a window in form, if it is possible at all, in Access. I know it is possible in Powerbuilder, but I do not own Powerbuilder or know anything about it.

Thanks

 

[mhartman1]

Hello:

It would be better if your just opened your report in PREVIEW mode in your application with a button or event.
'
Something like DoCmd OpenReport "Your Report Name", AcPreview

Regards
Mark

 

[TheAceMan1]

How are ya bddewell408 . . . [purple]Whats wrong with opening the report in Print Preview and allowing the user to print or cancel? . . .[/purple]

See Ya! . . . . . .

 

[bddewell408]

What I am envisioning is being able to scan the reports very easily without opening and closing a lot. I would like to have an option group with all of the reports listed. Simply select a report, it would appear in the box, and then a command button which prints the active report in the window.

I have taken away all toolbars, and don't want to let them have the print preview toolbar either, I guess I could make a custom toolbar with only CLOSE on the tool bar for reports. I just like the way I saw this one database that never opened a report in print preview mode in a seaparate window.