Subform Magically appears

[aziz rasul]

I have inherited a database where I have a main form containing a subform. When the linked data matches the subform becomes visible otherwise it's not there. What I'm trying to work out is how this is being done. In code there is no reference to the subform.

 

[Mr. B]

It it typical for a subform to appear blank if there are no records linked to the main form. Most likely what has been done is that several of the properties of the subform, like the Border, etc, have been set to be transparent and therefore it appears that the entire subform is disappearing. .

 

[aziz rasul]

OK I understand, but when I change the BorderStyle to solid in the main form and the single label and text box and subform in the subform it still don't show up even if I go into the design view of these controls and have changed the BorderStyle to solid. I can only gues that as you said if there is no record, then it just doesn't show up. The subform is in form view not datasheet view.

 

[vbaInet]

This will explain most of what is going on:

http://allenbrowne.com/casu-20.html

 

[aziz rasul]

Thanks vbaInet. Useful stuff to know for the future.

 

[vbaInet]

No probs!