Hi my friends
Im designing an accounting form with these fields in a continous subform. Next to the Field names below Ill give you an idea of what Id like to try and do.
If I click the date text box on my continous form Id like an imput box to pop up so I can enter the date in it and after I close it the date would populate the text box
This is a combo box which has 3 selections 1. Payments 2. Income 3.Bank Transfers. If I select option 3 which is Bank Transfer Id like a popup tp appear enabling me to
transfer the whole accounting entry line into the account Im transferring it to. How would I go about doing this?
Date If I click the date text box Id like to have an input box where the date can be entered and after closing the input box it would automatically save into the date field for that entry
Type This just describes what the transaction is. Its a combo box which I would like to be able to add new entries to it so it would remember all entries and I can select from the combo list
Category This is a combo box which selects the accounting Category.
Payment This is a text box which payments are entered
Receipts This is a text box where receipts are entered
Balance I would like a running sum total which calculates the total from payments and receipts but would also like to have a way of entering the open balance
Ive been working on several ideas but as usual the best ideas come from you guys and any thoughts on this will be received with much anticipation and enthusiasm