I have attempted to create a form which would allow me to enter data in a transaction table and then be used as a report in the format of a bill.
The transaction table has:
autoID
unique member ID
Last
First
Event
Event Code (an alpha/numeric category code)
date
check number
amount


debit amount
debit code (an alpha/numeric category code)
credit amount
credit code (an alpha/numeric category code)
balance

My goal was to have the form populate the transaction table using the unique member id. The form results I get is a view of a specific member's single transaction.
I want the form to be a template.
Now I have to create 55 separate queries.
Also I want the balance column to reflect the current debit or credit using the previous transaction balance entry.

Any suggestions?