Subform within a form

  • Thread starter Thread starter PJ
  • Start date Start date
P

PJ

I have a subform (frm Grid Pricing) within a main form (frm Tranche). I have
a text box in the subform that I want based off of a text box in the main
form. The text box name in the main form is cmbGrid Pricing Format with a
control source of Grid Pricing Format. So if "CDS/CDX" is selected in the
text box named cmbGrid Pricing Format I want the text box in the subform to
say "Floor". The below is what I came up with but it is outputting #Name?

=IIf([frm Tranche].Form![cmbGrid Pricing Format]="CDS/CDX","Floor","Drawn
Pricing)

Any Ideas??

Thanks in advance.
 
PJ said:
I have a subform (frm Grid Pricing) within a main form (frm Tranche). I
have
a text box in the subform that I want based off of a text box in the main
form. The text box name in the main form is cmbGrid Pricing Format with a
control source of Grid Pricing Format. So if "CDS/CDX" is selected in the
text box named cmbGrid Pricing Format I want the text box in the subform
to
say "Floor". The below is what I came up with but it is outputting #Name?

=IIf([frm Tranche].Form![cmbGrid Pricing Format]="CDS/CDX","Floor","Drawn
Pricing)

Any Ideas??
Click to expand...


From the sound of it, what you are calling a text box is actually a combo
box. Not that that really matters in this case, but in general you'll get
better answers if you use accurate terminology.

Try this controlsource expression:

=IIf([[Paren]![cmbGrid Pricing Format]="CDS/CDX","Floor","Drawn
Pricing")

Note: that may have been broken onto two lines by the newsreader, but it
should all be on one line in the subform text box's Control Source property.
 
Back
Top