Multiple Single Page Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I am attempting to print a one page report (rpt_ltrLicense), based on a
"tblEmployee", for each record in the table that has a "expirationdate" that
is within 15 - 60 days of Now.
I am using the onclick command of the command button on the "Reportsmenu",
which opens the table and recordsets and then loops through the recordsets,
checking the field "expirationdate" against two variables ("mdate" which is
"now" + 15) and ("sdate" which is "now" + 60). If the criteria is met, it
fires the "docmd.OpenReport strDocName, acNormal", else it ignores the record.

Problem: It finds all the records, and prints out one page for each record
selected - BUT - all records have ONLY the information from the first record
located..
OBVIOUSLY - I screwed the pooch here. Any help appreciated.
Thanks,
 
Sounds a bit long winded. Why not base a report on a query or open with a
where condition, and set the ForceNewPage property. This will give you the 1
record per page, and avoid having to loop through records.
 
Back
Top