Form/Subform Problems

[Keith]

I have a form [FrmBooking] that has an unbound text box [Total] that calculates a total price from several fields on the main form.
I have a subform [FrmTrans] and I wish to transfer the contents of [Total] to a subform field [SellPrice] Try as I might I can't make it work. I can get data from bound fields to copy across but not from unbound ones.
Help please I'm going Grey.
Keith

 

[chrismcbride]

Try setting the value of the target field in the AfterUpdate of the source field. This could be done with a direct reference to the field value {ie Forms!FormName!SubFormName!TargetFieldName = Me.SourceFieldName}
or by reproducing the caluclation that gave the source field it's value {ie Forms!FormName!SubFormName!TargetFieldName = (me.price -(me.price * me.discount)) * me.ordered }
Good Luck
Chris

 

[Keith]

Chris I have tried both your suggestions without any luck.
Thanks anyway
Keith