F
FJquestioner
I have a form to record customer payment receipts. Within that form is a
subform based on a query that selects all open invoices to that customer. I
want to be able to allocate the receipt among those invoices that are being
paid (in full or in part). Ideally, I'd have the open invoices appear in
datasheet view and beside each record I'd have a field to enter the amount of
the receipt to be applied to that invoice and a checkbox to indicate whether
that payment closes the invoice or not. I know how to put this info into
the appropriate table using Set Value Macros but I don't know how to set up
the form so that the control and checkbox appear at the end of each open
invoice record row. Can anyone explain to me how I can set this up
efficiently( (without resorting to writing code - but Macros are within my
competence level).
Thanks a lot.
subform based on a query that selects all open invoices to that customer. I
want to be able to allocate the receipt among those invoices that are being
paid (in full or in part). Ideally, I'd have the open invoices appear in
datasheet view and beside each record I'd have a field to enter the amount of
the receipt to be applied to that invoice and a checkbox to indicate whether
that payment closes the invoice or not. I know how to put this info into
the appropriate table using Set Value Macros but I don't know how to set up
the form so that the control and checkbox appear at the end of each open
invoice record row. Can anyone explain to me how I can set this up
efficiently( (without resorting to writing code - but Macros are within my
competence level).
Thanks a lot.