Hi, I'm trying to automate Fax Cover Sheets that have to be printed along with reports that are generated out of a journal entry database. The issue I'm having is I don't have the foggiest idea of how to write code that will pull the number of pages that will print off for each report and put that number in the "Pages Included" field on the form. The report is based on a single table and prints separate Journal entry back up documentation off via page breaks, each of these separate sections have to be faxed in with a separate fax sheet and I want to have the database generate these fax sheets as well. I'll have drop downs for the other fields needed but I'm not sure how to have it count the number of pages based on the Journal Entry number they select in the J/E field on the fax Sheet. Anyone have any suggestions, or has anyone done anything similar?
Thanks for all your help.