Using only certain records in a form

[Gamezy]

I have a form at the minute that is able to list print cartridges by selecting a combo box. I am not sure how I can get a report to then print this list.

I think it's an SQL query that I need, but I'm not sure where to put it.
(catch you after the weekend, any response would be great thanks!)

 

[whitesmoke]

either have the user click on file print or user the docmd.openreport "reportname" , acviewnormal