Running a report from a button in a form

[indi]

I am using Access 2003.



I have a form to enter information from customer orders. There is a sub form in the main form where you enter each row of the order. The main form refers to a table called tblPurchaseOrder, the sub form displays information is a column format, data entered in this sub form is linked to a table called tblJobs.

I have a report that I need to run for each job (rptMouldingRequet). When I open the report it asks for a job number and then populates the report from this. Someone else created this report.

What I would like to do however is have a button on the form that allows me to select a job number row from the subform and print the report from this. This is easier than having to firstly find the job number and then go into the report etc.

I can create buttons without a problem - only trouble is they don't do anything

Can anyone please help me? I'm not sure where to start.

Thank you.

[RuralGuy]

My preference is to base the report on a generic all inclusive query and limit the results using the WhereCondition argument of the OpenReport command. It applies a filter to the report query and seems to work quite well in most cases.