Refer to account Table

[isaya]

Hello guys!! I have ms access project, I need to create a program that will help me manage my income and expenses, On this i have created three tables, tblIncome, tblExpenses and tblAccount! I need when entering the data in Income form! The amount to go direct to the Account! And in Account form i have entered Bank accounts and the respective amount! My Question is! How can the amount be deducted from the Accounts when i enter the expenses! Because in the expenses form there is a combobox that shows the account i want the amount to be deducted from! So from there i need when i choose the bank from the combobox the amount to be deducted from Account Table

[twinnyfo]

isaya,

Welcome to Bytes!

I would recommend having all transactions in one Table and calculate balances at run time in your forms and reports.

Even better, the headaches involved with trying to develop your own MS Access accounting project are not worth it. You can get an inexpensive off the shelf software package that will do you much better in the long run. There might even be some free options.