I have a pre-printed form that I've basically duplicated in Access 2000 with
the form wizards. It uses a main form for the basic info on a client, then
a subform for the transaction lines. I've tweaked it "just a bit" with code
for defaults and stuff, but otherwise, it's pretty much the way the wizards
created it (both main form and sub-form).
However, I need to either limit the number of transactions my user can
input, or limit the number of transactions that will print to 8 on each
form, printing 8 on the 1st form, the next 8 on the second, etc until all
transactions have printed. However I do it, I can only have 8 transactions
printing--that's what my pre-printed form requires.
Which would be easier? Limiting the input into the tables? Or, allowing
unlimited transactional input but only printing 8 transactions per page and
then reprinting the main form with the next 8 transactions, etc. I also
need the total of the amounts (which is the normal charge * quantity on the
subform) for each individual form to be listed just after the 8 lines of
transactions for each printed form (but if there aren't 8 transactions, the
totals for the transactions still need to print in the same place).
I actually wanted to limit the input at first, but just couldn't figure out
how, so I've been playing around with the printing limits and I've got it
kinda okay(I've just made the page header and page footer really large to
include all the stuff I need for each form and that limits the transactions
that'll print), but I just can't get the totals to print for each form.
I've been beating my head against the wall to come up with a solution. Can
anyone suggest something that might work?
TIA
ron