I really want a report on my form

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

Hello All -

I'm working on my main form. I really want to [insert a
report I have developed] on this main form. But, I notice
in forms design when you select insert a
subform/subreport, I'm forced to select a table, query, or
form - it won't let me select the report I created. The
problem is by basing the subform/subreport on the query I
created, I get the "ugly" query results itself - no
formatting, color, etc. If I then go to the subreport
that was created during this process, I can do all the
formatting, but only the first record displays. So if
there are 10 different program names returned from the
query, you only see the first one unless you use the
navigation buttons to "page" through each program name.

Are there any solutions to this? Again, my actual report
that I created from the query itself is exactly what I
want and need to put on my main form, but I can't figure
out if this is even possible.

Thanks in advance for your advice!!!! Karen
 
Try this, it has worked for me.

Create a command button on your main form and set it to
open the report (I would recommend in Preview mode). NOTE:
The wizard will walk you through the steps, if needed.
You might need to adjust the query for the report to use
the criteria needed from the main form. From there, you
can print it out or just view and close.

Hope this helps.
 
Back
Top