Access report pass parameter to subreports query

Question

I have an access report which contains information about a given job. I'm trying to add a subreport that will display some detail information about that job, but I need to pass the job's number into the query the 2nd report uses. How is this done in access vba?

Is there some command which will let me run the query with the passed parameter before I display the subreport?

Answer 1

The simplest way to connect a subreport to a main report is using the LinkMasterFields/LinkChildFields properties of the subreport control.