Hiding Subforms 1

[sera]

I have a command button that shows/hides a subform OnClick.&nbsp;&nbsp;The code that I am using to do this is <br>me![subform].visible=not me![subform].visible<br>Does anyone know how I can make the subform hide until the user clicks the button?&nbsp;&nbsp;Currently, the user has to click the button to hide the subform.<br>Thanks <br>Sera

 

[jimmythegeek]

On the OnOpen event of your form put:<br><br>Call cmdButton_Click<br><br>(Change cmdButton to the name of your button) <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development

 

[sera]

That worked well, thank you.&nbsp;&nbsp;I am curious about one thing, however.&nbsp;&nbsp;On the main form I have five subforms.&nbsp;&nbsp;One of the subforms is hiding itself automatically, I didn't do anything to hide it(programatically that is).&nbsp;&nbsp;When I use your procedure to hide the other forms it reverses the process of the wayward form.&nbsp;&nbsp;I implemented the hide/show<br>command the same on every command button.&nbsp;&nbsp;Any ideas?<br>thanks,<br>Sera&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;