C
CotoJoe
I am trying to setup a database of 50 or so bank accounts. I have table for
the accounts and one for the transactions.
I then setup a form with the account information on top and a subform for
the transactions. I am having 3 problems:
1. I want the account information to be selected to bring up the
transactions on the subform, but I don't want the account information to be
changed. When I get the information on the form from the table, it allows me
to change the information.
2. I get the account information on top to work as a drop down and limit
input to data in the account table
3. I get get the account balance for each account (i.e. sum of all
tranactions for the account selected) to show on the footer of the subform,
nor can I get a button on their to add a transactions.
Help in anyway is appreciated.
My e-mail is [email protected] if you need it.
the accounts and one for the transactions.
I then setup a form with the account information on top and a subform for
the transactions. I am having 3 problems:
1. I want the account information to be selected to bring up the
transactions on the subform, but I don't want the account information to be
changed. When I get the information on the form from the table, it allows me
to change the information.
2. I get the account information on top to work as a drop down and limit
input to data in the account table
3. I get get the account balance for each account (i.e. sum of all
tranactions for the account selected) to show on the footer of the subform,
nor can I get a button on their to add a transactions.
Help in anyway is appreciated.
My e-mail is [email protected] if you need it.