Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make a subform control on a form invisible on certain situation

Status
Not open for further replies.

cfvcf

Technical User
Nov 8, 2007
77
US
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!
 
Sorry, I found out how to change the visible property, but I may be back. Thanks if you took the time to read this!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top