One form is a subform on many forms

[connerlowen]

HI,

I am working on a database to generate quotations. Within each quotation there could be a straight part, or an assembly. Within each assembly there could be a part, or a sub-assembly. Within each sub-assembly there are parts. There could be anywhere from 0 to 5 metals within each Part.

With all of that being said the Form for the Part is a subform. There are some textboxes that only pertain to certain parent forms. How can I make the text boxes visible only when the Part Subform is part of a certain parent form?

Thanks,

Conner Owen

 

[connerlowen]

I figured it out.

I used the Me.Parent.Name property and it works like a charm.