Reference hierarchy

  • Thread starter Thread starter SillySally
  • Start date Start date
S

SillySally

Hi. I have changed my form design and have lost my
reference field control source.

I had:
=IIf(Len(((Parent![cboMemCat].[Column](2))) & "")=0,
Null,(Parent![cboMemCat].Column(2)))

But now, the field I am trying to create a reference for
is on a subform (DuesLineItem Subform1), on a form
(DuesHeader1), on the main form (Individuals).

I realize that Parent no longer refers to the correct
form since the parent of (DuesLineItem Subform1)is
DuesHeader1, rather than Individuals where cobMemCat
resides. I tried to substitute Individuals for Parent,
but that didn't work.

Any suggestions? Thanks.
 
I was able to get the correct reference by bringing the
field first to DuesHeader1 footer and then to
(DuesLineItem Subform1).
 
Back
Top