Unanswered: Help tab control and specific tab visibility
I have a database set up where the user enters various demographic information for a study participant into the main form. I have also placed a tab control (with 3 pages each containing a subform) into this main form.
What I want to happen is that, when the user selects a value from a combo box in the main form, one of the 3 pages in the tab control will no longer be visible.
To be specific to my database, that combo box has a list of 6 Churches that a study participant can belong to. The user of the database will, through that combo box called "ChurchID", select which of those 6 churches each participant belongs to.
If a Church numbered 1, 3, or 4 is selected, I'd like one of those pages in the tab control to no longer be visible. If a Church numbered 2, 5, or 6 is selected, I'd like a different one of those pages in the tab control to no longer be visible.
Can someone please help me with this code?
I think part of the following syntax will work, but I am not sure how to code the rest: