CODEWITHSUNDEEP
ms-accessvba
MAW74656
MAW74656

Reputation: 3549

Access report pass parameter to subreports query

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?

Upvotes: 1

Views: 1372

Answers (1)

mwolfe02
mwolfe02

Reputation: 24237

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

Upvotes: 3

Related Questions