Subform lookup control

[iattlakerod]

I've created a form with a subform on it. On the subform I'm looking at 3 fields.

Form name is: RepairOrder
Subform name is: RepairOrderDetails

1) Part#...........combo-box
2) PartName.....combo-box -updated when user selects part#
3) Warranty......check box-Yes/No

After the Part# is selected the PartName Combo-box is automatically updated. I need to use a "check-box" to show if this part is a warranty item or not(from "parts" table).

In the checkbox controlsource if have:
=IIf(DLookUp("[warranty]","[parts]","[partid] = Forms![RepairOrderDetails]![partid]")=0,"No","Yes")

What's my problem?
Note: When I open the subform by it's self It works great, but while open as the subform the status bar keeps showing Recalculating......and the checkbox field is greyed out.

 

[Rich]

You have to have the full forms reference
Forms!MainForm!Subform!Control

 

[iattlakerod]

Rich, thanks a lot. I kept trying to put the subforfm control info there but only worked when the subform was open by itself. This will be a useful tip. Thanks for the help. Oh, it worked by the way.