Printing subform data

S

SirPoonga

I haven't used any printing functionality in Access before so I don't
know where to start.

I have a form with a subform. The controls in the form setup a filter.
Click a button and it filters the records in the subform by setting
the subform's filter, order by, recordsource properties.
The subform is in datasheet view.
I'd like to make a print button that prints the data that has been
filtered in the subform.

My guess is the best way to do that is setup a report. Set that
report's properties to same as the subform and print it? How would I
do that in code? Is there a better way?
 
S

SirPoonga

Dim myReport as Report
Set myReport = Reports("rptSubformQuery")

I tried that but it says the report doesn't exist. I copy and pasted
the name of the report.
 
T

ti976

easiest solution would be to set your report's recordsource the same as
the subform. Using your main form's 'filter' controls construct a SQL
string to pass to the report when you call it open (in the
[WhereCondition] parameter).
Another possibilty is to access the subform's property and grab the
source and filter info and pass it to your report. I can't remember if
I've done this before so it may not work.
 
S

SirPoonga

How do I do this? I am getting erros of not being able to find the
report witht he code I am trying.
 
Top