Field from a subform in a main form

[AChir]

I have a form containing a subform. Each line of the subform contains a memo field "Notes". There is inadequate room on the subform to enter data into this section so I'd like the current record's "notes field to be duplicated asd a field on the main form. Can anyone help me do this,please? I have tried an unbound field with
= [MySubform]![Form].[Notes]
but this just gives me a Name? error

Thanks

Any help

 

[Oldsoftboss]

Try =Forms![main form name]![subform name].fieldname
or try [where it goes to]=[where it comes from]
ie: Forms![main form name]![subform name].fieldname=forms![main form name].fieldname
put this code in an after update or on lost focus on the field on your form.
HTH
Dave

 

[Rich]

Why can't you use the standard Zoom box, much easier and less likely to cause errors.

 

[AChir]

Will look up Zoom boxes, thank you - I haven't heard of them! Using the [Forms]!etc didn't work - it couldn't find the field forms - or didn't upport this method - depending on where I put the code

Thanks for the help -am on my way to look up Zoom