Filter by selection Print

[SPM2]

I have a combo box on a form that once a selection is made a subform is made
visible using the selection made through the combo box. Now I filter this
subform to get specific data. What I need is to print the data that is
filtered, but when I try to print, I am getting all the information that
came with my selection from the combo box. Any Suggestions?

Thanks.

 

[Damon Heron]

Try the print menu (instead of print button) and select "print selected
records". This works on my subform when I filter by selection....

HTH
Damon

 

[SPM2]

This does work but I was hoping to do it using code behind a command button
on the main form.


Try the print menu (instead of print button) and select "print selected
records". This works on my subform when I filter by selection....

HTH
Damon

 

[Damon Heron]

If you want to use a command button, why not just create a report instead of
printing form data? It would look nicer, you have much more control over
the format.

Damon

 

[SPM2]

Yes it would be nicer, can I actually by using the selections from the
subform create a report from this?the person who will be using this wanted
access to the table, so he could filter whichever fields he wanted and Then
print from the table, and he said that he didn't know which fields he would
be needing until he actually wanted to do it.


If you want to use a command button, why not just create a report instead of
printing form data? It would look nicer, you have much more control over
the format.

Damon

 

[SPM2]

I've tried using the reports like you were saying, Thanks for putting me
unto this route. Now it is just to see how the user feels about it.

Again Thanks

If you want to use a command button, why not just create a report instead of
printing form data? It would look nicer, you have much more control over
the format.

Damon