I have a report that is created with a command button. Data printed is dependent on what record is being displayed. The data can be grouped into 5 different classes (call them A, B, C, D & E). The data is aggregated into a query from different tables using a primary key. Besides txt fields tied to certain fields in the query, I build a memo field using the data for that class of data shown. The system outputs the report to a pdf file. The routine outputs the required data for all classes and for classes A - D, creates a two page report as expected. For Class E, the routine outputs the data into a two page report, but creates a pdf file with 162 copies of the two page report. This class E was the last sub routine I built, so I commented out the code that creates the memo field, but still get the same results; however, if I create a report for a different class of data right after I run Class E, I get the desired 2 page report (1 copy). I have compacted and repaired the DB as well as quit Access and restared.
Any help would greatly be appreciated.
Thanks
TC :banghead:
Any help would greatly be appreciated.
Thanks
TC :banghead:
