Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    66

    Unanswered: Displaying a Report on a form

    Okay I have a form and at the bottom of this form i want a report to display as a subreport. It won't let me use a subreport on a form. It only will let me use a subform. It there any way to do this? I don't want to use a subform because the report is formatted exactly how i want to display it. Any suggestions?

    Thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    Forms are based upon a single record source. You essentially want to add two or more. The only way to do this is with a union query. Both queries need to return the same # of fields. If different you'll get an error (I recall?), you could use dummy fields and fill them with a "0" or other appropriate data based upon type of field (text, num, etc). You would probably need to use a continuous form, too. So, if you wanted empty rows between forms you'd have to fill the bottom of the first table.

    I have done something like this to create a table of subtotals where I had about 6 different queries unioned as I wanted.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •