B
babs
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
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