>Can someone help me with the correct syntax for the following line?
>
>replace this.Parent.tLcost6.controlsource with this.parent.txtLcost_6.value
>
>Thanks
What is .tlcost6?
this.Parent.tLcost6.value = this.parent.txtLcost_6.value
This assumes that tLcost6 is a form field bound to a table field. Equating the two will auto. change the value in the table.
ControlSource is typically TableName.FieldName. You only:
replace Fieldname with value in TableName
in FP.
ControlSource is a character string and you'd need to parse outr the "fieldname" part and macro substitute it in the replace command.
HTH
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.