subform question

[eric.l.bohon]

Question. Have a form with multiple subforms in it. Now the subforms are based off different querys. What I am trying to do is if one of the querys does not have any info in it, then the subform based off that query on the form disapears and shows what is behind it. when I test it on the query and go back to the form it goes away but leaves a white box instead of showing whats behind it. I even have tried the can shrink and that did not work. can anyone help me with this.

 

[VicRauch]

Make the SubForm Control hidden.

Forms!MyForm!MySubFormControl.Visible = False

 

[eric.l.bohon]

if this is a vba, not realy good with them. how do i get it to reconize the subform. one of my subform is named SUBFORM HOSPITAL/QTRS.