Send a form field to a report

[jeffwest21]

Trying to send the value from a form field to a report

DoCmd.OpenReport "Agent_Report_BR_Com", acViewReport, , "Mon_ID = " & Me.ID.Value

Mon_ID is the field on my report, me.ID.Value is the field on the form.

It picks up the data from the form but doesn't seem to send it to the report so that a query can read that field on the report to filter a table to grab the data.

What am I missing??

'Clever boy...'

 

[dhookom]

Mon_ID must be a field in the report's record source. "Me.ID" must reference a control/field on the form that is running this code.

Duane
Hook'D on Access
MS Access MVP