print report using form criteria

[deb]

Hello All,

I am using Access2K and VBA. I have a query by form which has several list boxes. The form filters by the choices selected in the list boxes and displays the results in the sub form embedded at the bottom of the master form. The subform's row souce is fed by the list box selections on the master form using VBA.

By clicking a button, I need to be able to send this criteria via VBA to the query that runs the report and then have the report open. The report should then have only records from the form selection.

Please help, I'm goin crazy over this.

 

[mdmilner]

It sounds like you've already done the work of building the modules that allow you to control the record source.

Just like you probably modified the subform Recordsource, extremely similar syntax allows you to modify a Reports' Recordsource.


Go into the VBA function(s) that you setup to feed the recordsource to the subform. Add a string variable that will hold the full SQL expression of a query representing the fields AND parameters you wish to use.

You can then pass the value to Reports!report_name.RecordSource.

Mike

 

[deb]

Thank you for your help.

I am learning Access so I appreciate you patience.


How do I pass the value to Reports!report_name.RecordSource?