I have a form that has data fields in the form header and then a subform in the form detail. What I want to do is use the form that shows a bank name addr etc in the header and then in the detail show all accounts I have from that bank. I "currently" use the form for both new and existing banks and the subform is used to add the accounts.
I want to change that form for "new" banks to not show the subform and only allow input to the bank info in the header of the form form the bank, then I have a button to add an account that will add the bank to the bank table and link to a new form to add the account. From there I will have a button to save the account and it will take them back to the form that shows the bank info and the subform will show the accounts with that bank. When one of the accounts is clicked, it will take them to the detail page for that account and the information can be changed there. Then they can go back to the form that has the bank header and accounts so simply go back to the main menu.
I'm not sure how to change the subform .visible property to do all of this. Any ideas and is my approach not the right way? Should I have a totally different form for new banks or could this work?
Appreciate your help!
I want to change that form for "new" banks to not show the subform and only allow input to the bank info in the header of the form form the bank, then I have a button to add an account that will add the bank to the bank table and link to a new form to add the account. From there I will have a button to save the account and it will take them back to the form that shows the bank info and the subform will show the accounts with that bank. When one of the accounts is clicked, it will take them to the detail page for that account and the information can be changed there. Then they can go back to the form that has the bank header and accounts so simply go back to the main menu.
I'm not sure how to change the subform .visible property to do all of this. Any ideas and is my approach not the right way? Should I have a totally different form for new banks or could this work?
Appreciate your help!