vangogh228
Registered User.
- Local time
- Today, 14:33
- Joined
- Apr 19, 2002
- Messages
- 302
Hello all.
I have a customer-level form, with invoices showing in a continuous subform. I want to be able to prepopulate a number of reports (that duplicate current manually-filled paper documents) with customer-level information AND invoice-level information.
I was thinking about putting a single button on the subform, at the invoice level, that when clicked would bring up a subform allowing the selection of the specific report (there are 9 in all) that is desired from a set of buttons. Then, if any ad hoc info is needed, a small secondary form would open and, with a final button click, information would be gathered from the customer info and the invoice info to populate the already-existing info into the report, with the ad hoc just typed in.
There's got to be a better way of doing this... and even if I do it this way, I need some help on button code to capture this multi-level info. I need some way of selecting the appropriate invoice, so I thought of the "button on the invoice level" idea. But then, the button would appear on every record. Is this the way to do it, or would it be better... and again, I'm not sure I know how to do this... to have a checkbox on each record so that multiples could be selected prior to selecting a report for population?
THANKS for any help!!
Tom
I have a customer-level form, with invoices showing in a continuous subform. I want to be able to prepopulate a number of reports (that duplicate current manually-filled paper documents) with customer-level information AND invoice-level information.
I was thinking about putting a single button on the subform, at the invoice level, that when clicked would bring up a subform allowing the selection of the specific report (there are 9 in all) that is desired from a set of buttons. Then, if any ad hoc info is needed, a small secondary form would open and, with a final button click, information would be gathered from the customer info and the invoice info to populate the already-existing info into the report, with the ad hoc just typed in.
There's got to be a better way of doing this... and even if I do it this way, I need some help on button code to capture this multi-level info. I need some way of selecting the appropriate invoice, so I thought of the "button on the invoice level" idea. But then, the button would appear on every record. Is this the way to do it, or would it be better... and again, I'm not sure I know how to do this... to have a checkbox on each record so that multiples could be selected prior to selecting a report for population?
THANKS for any help!!
Tom
