I have a switchboard – button #1 will open the data entry form in Add mode, and button #2 will open the same data entry form in Edit mode. The form itself has a series of fields at the top, then at the bottom a subform with 2 tabs on it with more fields. I will call the tabs A and B for reference. If a certain combo box on the main form has selection “A” selected, then I have code in the Update Event of that combo box to hide tab B because there are questions that do not apply, the user will only need to see tab A at this point. Vice versa too – If the combo box on the main form has the “B” selection, then tab A on the subform will be hidden and the user will move forward with data entry on tab B.
This all works just fine in the “Add” mode from the Switchboard navigation. However, when I go to Edit previous records from the second button on the Switchboard (which will be important for users to do) - the records I entered dummy data into show both tabs instead of the one that applies to the combo box selection. I have tried entering some code into the Load Event on the form (an "If" statement that asks to hide the tab based on the combo box) but that doesn't seem to work. Is what I want to happen possible?
Thank you in advance