t1hodges
MIS
- May 8, 2003
- 54
I need to print multiple reports from MA Access and each time have the report data source filtered each time a report is printed.
for example,
I have table1 that contains the field "name" and three values: Tom, Dick & Harry.
I have table2 that contains the field "name" the same three values from table1, and a second field of data called "address" that contains an address value for each of the three names.
I have a query called qry1 that uses table1 as its source and selects all values.
I have a query called qry2 that has table2 as its source.
I have a report called rpt1 that uses qry2 as its source.
How can I create a DAO vba function to print rpt1 for each name in qry2 while the field "name" in qry2 is being filtered by the field "name" in qry1?
for example,
I have table1 that contains the field "name" and three values: Tom, Dick & Harry.
I have table2 that contains the field "name" the same three values from table1, and a second field of data called "address" that contains an address value for each of the three names.
I have a query called qry1 that uses table1 as its source and selects all values.
I have a query called qry2 that has table2 as its source.
I have a report called rpt1 that uses qry2 as its source.
How can I create a DAO vba function to print rpt1 for each name in qry2 while the field "name" in qry2 is being filtered by the field "name" in qry1?
