Passing value from form to sub form query

[CS_10]

Hi there.
I have a form that contains a sub form on it.



On this sub form I have a report that produces a list of the information entered in the sub form that is related to the record on the form.

Currently I have to enter the ID that I want as part of the query, however, I'm sure there must be a way to automatically pull this ID field through from the main form?

Can anyone help?

Thanks,

Craig

[June7]

You have report object on a form?

Did you set the Master/Child Links properties of the subform/subreport container control?

[CS_10]

Hi there.

The report isn't directly on the sub form.

I have a button on there which triggers a query for the report.

It's a value from the main form that I want to pass through automatically to the query so I don't have to type it in the prompt.

Thanks. Craig

[June7]

I don't use dynamic parameters in queries. I use WHERE CONDITION argument of OpenForm or OpenReport.

DoCmd.OpenReport "report name", , , "ID=" & Me!ID

Access Help or web have more info on those methods and their arguments.

[CS_10]

I don't use dynamic parameters in queries. I use WHERE CONDITION argument of OpenForm or OpenReport.

DoCmd.OpenReport "report name", , , "ID=" & Me!ID

Access Help or web have more info on those methods and their arguments.

Hi June,

Thanks for the reply.
The report that I want to open currently gets its data from a query with a criteria on it.

Do I need to not use this query?

Or can I pass the value to the criteria prompt?

[June7]

If you are using a dynamic parameterized query as report RecordSource, review http://www.datapigtechnologies.com/f...mtoreport.html

I prefer not to use dynamic parameterized queries at all.