Show/Hide Columns in Subform
Posted on 2014-04-14
This is probably something mind-blowingly simple (or so I hope) but my brain is fried right now and I'm asking for an assist...
Have three forms:
FormSub is a form subform in BOTH FormS1 and FormW1.
In FormS1, I need ALL fields of FormSub displayed in a Datasheet view.
In FormW1, I need TWO fields of FormSub HIDDEN in the datasheet view.
How do I either:
Detect which form is the parent from FormSub (then I can easily use ColumnHidden = True/False)
Set the fields' ColumnHidden value in FormSub to True/False FROM the parent form.
I cannot seem to figure out how to reference the form! I would have thought Form!FormSub.Field.ColumnHidden = True or Me!FormSub.Field.ColumnHidden = True but that doesn't seem to be working for me...
your assistance is greatly appreciated.