Report Preview inside a Form

[H J]

Is it possible to create a report preview inside of a form? I have a user
who wants to view 5 pieces of equipment linked to a single site. I have the
site information in 1 table, and the equipment information in another table,
each site can have any number of pieces of equipment (the user only wants to
see the first 5).

They initially wanted the information to be displayed as part of the form,
but I can find no way of displaying 5 records at one time on a form. So
believe that a report would be the best way to show this information,
however I can't figure out how to get this to show in the form. I have a
query that takes the site ID when the form is loaded, to show equipment for
that site, and created a report based off this query.

Is this possible?

Thanks.

 

[Beetle]

Why not just use a subform? Use the query you were going to use
for your report as its recordsource and make it a Continuous form
or a Datasheet.

To answer your question, no you can't display a report inside of a form
(at least not that I know of).

 

[H J]

Thanks for the reply. I previously had the data as a subform, however using
a subform I can only display the single record at a time.

I found this
http://www.access-programmers.co.uk/forums/showthread.php?t=102184&highlight=snapshot+viewer
but am still trying to figure out exactly how I use this and place it on my
form.

If nothing else then the datasheet view would work, its just I would prefer
it to look a little tidier from the end user point of view.