Form for Payment Acceptance

[Brook]

I currently have a form to create invoices for clients,
which payment is due in 90 days of the Invoice. What I am
trying to do is set up a form/table that I can use to
accept payments on the Invoice. I would prefer not to have
Payment #1, Payment #2, Payment #3, and so on. I would
like to have it set up in some manner that when I pull up
my Invoice Payment form, I would be able to just enter a
payment amount and it would insert that payment and
payment date into the next payment field within my table.
I would also like to have the option to create an update
invoice if possible.

If anyone has any ideas, suggestions, or know of any
samples they can share that would be greatly appreciated!

Thanks,

Brook

 

[grep]

I currently have a form to create invoices for clients,
which payment is due in 90 days of the Invoice. What I am
trying to do is set up a form/table that I can use to
accept payments on the Invoice. I would prefer not to have
Payment #1, Payment #2, Payment #3, and so on. I would
like to have it set up in some manner that when I pull up
my Invoice Payment form, I would be able to just enter a
payment amount and it would insert that payment and
payment date into the next payment field within my table.
I would also like to have the option to create an update
invoice if possible.

If anyone has any ideas, suggestions, or know of any
samples they can share that would be greatly appreciated!

Thanks,

Brook

Brook,

I'd use another table for Payments, and then create a subform for it on
the main form. All your Payments would need to be linked to the Invoice,
so you'd be able to keep the records straight.

grep

 

[Brook]

Thanks for the information,

I have a limited understanding of how this would be set
up, do you know of anywhere I can download a sample to
look at?

Brook