I just purchased VIP service out of total frustration. Please help reduce my stress level!! I'll give as many points as I can to whoever can help.
I have a form with a subform for Bills of Lading reports. The main is bound to the bol_info table. The subform is bound to the bol_transactions table. Both tables are linked by the bol_number field. We have to print these Bills of Lading on an old-school, tractor fed, Dot Matrix printer with pre-printed BOL forms.
I have to limit each page to 8 line items in the subform. After 8 items, the new page starts. I have this working by playing with the size and placement of the subform within the main form. Multi-page orders print beautifully.
I already have the report grand totals printed at the bottom of every page (total units and total weight).
My problem is that I need to print the page totals on each page (units on this page and weight for this page).
For some reason, everything I have tried, whether it be just Access, or even VBA, everything seems to ignore the first page's data. For example...Page1 total will show Page2's first record, and Page2's total will show Page2's 2nd record.
I have tried the following examples, and it turns out they are all different ways to give me the same incorrect results.
I think I know why though. None of the examples mention anything about using a subform.
It does not matter to me if the solution must be done with Forms or Reports. Please help!!!