printing a filtered subform

[Annemarie]

I have a subform which is filtered by a combo box on the main form. When I
filter the subform, it displays the filtered results. When I try to print the
filtered results, it prints all the records, not the filtered records.

How do I fix this?

 

[BMusic]

Don't know if this is the right answer or not, but if you create a report
that runs off the main form, then you could print.

 

[Annemarie]

I'm not running reports, I just want to print what is displayed on the
subform when there is a filter applied. Right now, it ignors the filter and
prints the subform with all records.

 

[BMusic]

The only reason I suggested that is because all of the Access training I've
had says not to print from forms... that's the purpose of a report. You can
create a simple report that would show the same information as the form view
would, but would put it in a printable format.

Guess that's not going to work in your situation. Hope someone else has a
better answer... Good luck!

 

[Annemarie]

I'm not creating reports. I am just trying to print a filtered subform. I can
print the data just fine, but it prints everything, not the filtered results.

How do I print the filtered results from a subform?

 

[Jeanette Cunningham]

Annemarie,
a couple of options.
1--If the subform is open by itself without being a subform, you can
probably print the filtered results.
2--Use Print Screen.
3--Open a query that is the filtered recordsource of the subform and print
that.
4--Try using Tools > Office Links > Analyze it with Excel and print from the
spreadsheet.

Jeanette Cunningham

 

[Keith B Wilkinson]

Hi Annemarie

If you need to print the filtered subform you need to print the subform as a
seperate form filtered by the main form combo box.


1) create a copy of the subForm (rename)
2) create a print button on the mainForm that opens the (renamed) subform
3) In the properties list of the (renamed) subForm open
"On Active" enter the following :- MainForm.visible = false
"On Deactive" enter the following :- MainForm.visible = True
4) Print the (renamed) subForm
The mainForm remains open (but not visible) so that the (renamed)
subForm remains filtered by the comboBox on the mainForm
To get the resuts you need you must not close the mainForm.
5) When you close the (renamed) subform the mainForm will be visible.

Have Fun

Keith