Unanswered: Need to make subform visible based upon combobox selection
In an effort to make my database truly user friendly and dummy proof, I would like to build an expression or macro that would allow me to make a subform visible when a combobox displays a certain selection. Here is the setup:
I have a main form (header information) and three subforms Crab Survey Data, Bivalve Survey Data and Fish Survey Data. When a combobox (Survey Type) selects Crab, I want the Crab Survey Data subform to become visible. I have read solutions to no avail. Currently I have no expressions built.
From what I understand this could be done as an expression in the properties of the Survey Type field...is that true? If so, what is the basic syntax? Can I specify all three conditions in that expression? Could this be done through a macro? I would even settle for a button that manually makes the subform visible...at least that would be a start.