I am working in Access 2007.
I have a form that consists of several tabs. The tab I am working on has several subforms; only one displays at a time depending on a particular condition (ProgID = a particular value). This has all been working fine until I added a new subform. All the subforms have visible set to No on the Format tab in the Property Sheet and is conditionally set to True in VB in a case statement that checks the ProgID.
When I run the db, no subforms show up at all. If I change the newest subform to Visible = Yes, then that subform will display and if I am in another program (where the new form should not display), the subform for that program displays and the new one does too. I hope that makes sense.
Any suggestions on what is going on here? Why would all the subforms stop working when I added the new subform? As far as I can tell, all the properties are set up the same way.
TIA,
~RLG
I have a form that consists of several tabs. The tab I am working on has several subforms; only one displays at a time depending on a particular condition (ProgID = a particular value). This has all been working fine until I added a new subform. All the subforms have visible set to No on the Format tab in the Property Sheet and is conditionally set to True in VB in a case statement that checks the ProgID.
When I run the db, no subforms show up at all. If I change the newest subform to Visible = Yes, then that subform will display and if I am in another program (where the new form should not display), the subform for that program displays and the new one does too. I hope that makes sense.
Any suggestions on what is going on here? Why would all the subforms stop working when I added the new subform? As far as I can tell, all the properties are set up the same way.
TIA,
~RLG
.
