Printing Multiple Records of Same Report

[Guest]

Good morning,

A little probelm has stumped me and I have looked for the answer here,
without success. If someone could help, I would appreciate it.

I have a report, wherein all the record fields from a query (qry_ltrLicense)
are in the "report header section" of the report, and only the "page of page
and current date are in the "page footer section". Nothing in other sections.
This is a form letter, using labels in the "report header section" to convey
a message. The query (which compares a field (tblEmployee.LicenseExpire) to
the current (Now) date. This all works when the query is run (i.e., it shows
the correct records).

The report is fired from a command button on the "menuReportMenu" form,
using the following - DoCmd.OpenReport "rpt_ltrLicense", acViewPreview. (I
will later change it to acNormal after fiddling with the problem)

Problem: The report is only giving me the first record of the query and not
printing the remaining records (either in ViewPreview or when sent to the
printer).

Any thoughts on how I may correct this "glitch"??

Thanks

 

[Rick B]

Sounds like it is working as you designed it. If I understand your post,
you have all your fields in the "report header". There is only ONE report
header. You might try the "page header" if you want a separate page for
each record. I have not tested that though, so I can't be sure it will
work. Typically, I would use the detail section for the situation you
described and place a page break after the data.

Rick B