Show report's print preview as display in subform

[charlesfchang]

Hello,

I would like to show a report's print preview in a sub form. Is there any possible way? I don't want the user to see the datasheet view of the table so I decided to put on a report.

Any idea would be appreciated

 

[billmeye]

Unfortunately you can't display a report in a form and vice versa. But, you can duplicate the report in a form (copy all the controls and recordsource) and just set the form Allow Deletes, Allow Edits to false and the RecordSet Type to Snapshot and it is just showing the information like you would in the report.