Printing search results (displayed in subform)

S

susann

I have a database with around 5,000 records in it. Users are presented with
a form where they can narrow down their results by selecting certain
criteria. The results are shown in a subform below. I want the users to
then be able to print out their results. I'm not sure of the best way to
handle this (or even really where to start!). I think I need to create a
report? Can anyone help with pointing me in the right direction?

Many thanks
Susan
 
A

Albert D. Kallal

I would build a nice report based on the same table/query as the search
results.

(You've actually not clarified how you actually built or make the search
form function here).

Are you building your own SQL for the form, or are you using actually the
built in filtering ability of MS access?

if you're using the built in filtering ability, then build a nice report
based on the same table, and then open the form using the filter option of
the open report command

eg:

docmd.OpenReport "ReportName",acViewPreview,me.filter


its a little bit difficult to guess which approach works best for you not
knowing how your filtering your search form, but the above is a good
start...


If you're building the restrictions or filter fire your code, then I would
open the report with the where clause.
 
Top