Subform within a form

[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.

[Dirk Goldgar]

"PJ" <P...@discussions.microsoft.com> wrote in message
news:67898A6E-A929-4672...@microsoft.com...

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.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)