Copying data from main form to subform

[Gkirkup]

I am in a subform, and want to copy some data from a control on the 'main' form, to the subform, on a button click. How do I do that? This doesn't work:

Me.txtSUBCONTROL = [MAINFORM].Form![txtMAINCONTROL]

Also, on the same button click, how do I blank the data in the control on the main form? The button is on the subform.

Thank you!
Robert

 

[T.Smith]

Robert,

Have a look at:
http://www.mvps.org/access/forms/frm0031.htm
Hope this helps.

Toby

 

[Gkirkup]

That is an excellent reference, thank you.

Robert