How to see a report in a form

[ericb]

On a form, is a subform in which the records are presented in a datasheet
view. When a record is select a report is created. The report shows up in a
separate window. I want it to show up in a window under the datasheet on the
present form.

Then with the command buttons I can decide to either print or e-mail the
report.

How do I manage to display the report on the form.

Thank you

 

[Dirk Goldgar]

On a form, is a subform in which the records are presented in a datasheet
view. When a record is select a report is created. The report shows up in
a
separate window. I want it to show up in a window under the datasheet on
the
present form.

Then with the command buttons I can decide to either print or e-mail the
report.

How do I manage to display the report on the form.

There is no built-in feature for this, since you can't put a subreport on a
form. I can only think of extremely complex workarounds, which might not
work and I suspect would not be worth the trouble. As an alternative, it
would probably not be too hard to size and position the report preview
window in a specific location relative to the form. Would that do?

 

[ericb]

I guess it would do but the preview report window always shows up under the
present form.

The form is in a pop window.

How can I make the report window show up on top ?

Then I could size it and position it relative to the form window.

Thank you

 

[Dirk Goldgar]

I guess it would do but the preview report window always shows up under the
present form.

The form is in a pop window.

By that do you mean that the form's PopUp property is set to Yes?

How can I make the report window show up on top ?

Then I could size it and position it relative to the form window.

To do that, you'll have to set the report's PopUp property to Yes, too. I'm
not sure what version of Access introduced the PopUp property for reports;
it's there in Access 2003, and I don't think it was there in Access 97.