You are missing a left bracket. Try this:
"babs" wrote:
> I have a main form called Jeff Employee Info on there are two text boxes with
> rates on txtRate and one txtRate2BP (which is a second rate that could
> possibly apply for some jobs - that the employee may do.
> In the subform i have a check box called ckRate2bp that is set to default at
> blank - and I had the Actual Rate field in the subform set to have control
> source =Forms]![Jeff Employee Info]![txtRate])
> and it worked
> I would like to have the Actual rate in the subform be the txtrate in the
> main form but if the ckRate2BP check box is checked inthe subform I want it
> to be = to the txtRAte2BP on the main form
> =iif([ckRate2bp]=-1,[Forms]![Jeff Employee Info]![txtRate2BP],Forms]![Jeff
> Employee Info]![txtRate])
> I put the above code in the control source for the actual rate field for the
> subform but get Name? as a result???
> not sure what is wrong?????
> thanks,
> barb
|
