How to Transfer data from one subform to another?

Hi JANR

Yes the subformContainer name is definetely F_Order_line_subform.

Once again the same error is occuring, it now says it..

'cant find the field "Parent" in the expression.'

Or is parent supposed to be the form name which is F_Order?
 
Wow i finally got it to work! I swear i used the method before but never mind its working now. Thanks so much for your help guys! If your interested the final code was...

Code:
Me.Parent.F_Order_line_subform.Form!ProductID = Me.ProductID

Thanks again!
 
Parent is a property so must be precdeded by the dot operator. Basically the bang operator separates objects.

There are very few places where the bang must be used, so until you fully understand the difference it is best to stick with the dot.

One exception is where the bang must be used in the short reference to a field in the recordset of a subform. Note this is not a reference to the control on the subform even though the bound control may have the same name.

Me.subformcontrolname!fieldname
 

Users who are viewing this thread

Back
Top Bottom