creating IIF based on check box in sbform,grabbing rate frm Main c

[babs]

I have a main form named DateBarb with a combo box cboman - It has the Man
name with rate1 in the second column and rate2 in the third column of
combobox


On the subform if the field name [ckRate2BP] is checked I want field in the
subform [ActualRate] (I Named it txtActualRate) but field name is
[actualrate] to grab the the rate2 from the combobox:

Here is my code below - I attached it to the afterupdate event of the
ckRate2BP field on the subform - but also not sure if that is best place
since many times user may not even click on this check box if not second rate.

I am sure my syntax in referencing the field names and forms in incorrect -
Please help.

datbarbTimeCardMDJEFFSubform2!txtActualRate =
IIf(Me.Form!datbarbTimeCardMDJEFFSubform2!ckRate2BP = yes,
Me.Form!DateBArb!cboman.Column(2), Me.Form!DateBArb!.cboman.Column(1))

Thanks,
Barb