Is there a way to view a report in a form

[Jackblack1]

Is there a way to view a report in a form, and have a dialog box set the criteria?

Thanks

Jim

 

[Norie]

Can't you just have a button on the form to open the report?

If you want you could set the criteria based on textboxes (or whatever) on the form.

 

[Jackblack1]

Hi Norie

I wanted to have a text box or something be the frame around the report in the form. I have some dropdowns that list specific criteria. I don't know how to display the report in the form.

Thanks
Jim

 

[Norie]

Jim

Have you tried adding a subreport to the form?

I'm not 100% sure how they operate, I've never used them because it doesn't quite make sense to me having a report on a form.

 

[Jackblack1]

ok Norie

I'll give it a try and see, I'll lett you know if it works

 

[CoderX]

You can't insert a report into a form object directly. You can create a subform which can emulate most of what a report would show, but there are certain formatting issues that are difficult to program for.

However, if you are familiar with a snapshot object, then you could conceivably create a MS Explorer web browser object for your form, then link it to the browser, which can display the snapshot object within Explorer. In that way you can display a report, but in my opinion would be more hassle than the subform.

For the snapshot object, in VBA you would:

1. Create the report.
2. Export as a snapshot object to a location on your computer.
3. Link the snapshot to a local browser file.
4. Link the browser file to your Access form.

I've not tried this, but think it should work.