Hi, Im not that good at the programming aspect of access and I am trying to design a database for use for managing my accounts receivables. The problem I'm having is interacting between forms. Or having some elements on one form show up another.

Example I want to display the total amount paid on one form, but enter different payments on another but not sure how to pull it off. there are many more areas I'm stuck in as well but hoefully a few of you experts can help by looking at my database at
http://nobillcollectors.hypermart.net/images/debtmaster.mdb

any help would be appreciated.

I've looked at your database, but what are your specific questions?

well I want to creat a payment history form where i can of course enter in and track peoples payments. I then want to display on another form the sum of total payments so that I can then subtract from the principal amount and payments in order to come up with a current balance.