G
gvsandrs
I have tried over in over to set up a report to filter based on the method
recordset in VB from Access on the event procedure (onopen) of the report. I
am getting no where. I originally had the filter on the query that is the
record source of the report as a prompt for valule. Since I want no manual
intervention and I want the report to select each value automatically I
tried using recordset and the report only opens with all records and no
filter. Can some one tell me what the very first step is to getting this to
work. do I place the applyfilter as an onopen event procedure and then
create a separate macro to send the individual reports?
recordset in VB from Access on the event procedure (onopen) of the report. I
am getting no where. I originally had the filter on the query that is the
record source of the report as a prompt for valule. Since I want no manual
intervention and I want the report to select each value automatically I
tried using recordset and the report only opens with all records and no
filter. Can some one tell me what the very first step is to getting this to
work. do I place the applyfilter as an onopen event procedure and then
create a separate macro to send the individual reports?