Copy the value of a text box from one form to another form

[dominik@kartony24.eu]

Sorry for my english but i'm from poland.


I have a form called "Document" and attached to it as a sub-form - the "Details" form. This "Documents" form has another "Product" form. After pressing the button on the "Product" form, I want the name of the producer to be copied and pasted into the field on the "Details" form. The field with the product name is a text field on both forms.
What the VBA code should look like, which I will attach to the button

[June7]

You want code behind a main form to reference a subform? Must reference through the subform container control. I always name container different from the object it holds, like ctrDetails. So:

Me.ctrDetails.Form.prod_name = Me.prod_name

[dominik@kartony24.eu]

Sorry for my english but i'm from poland.
I have a form called "Document" and attached to it as a sub-form - the "Details" form. This "Documents" form has another "Product" form. After pressing the button on the "Product" form, I want the name of the producer to be copied and pasted into the field on the "Details" form. The field with the product name is a text field on both forms.
What the VBA code should look like, which I will attach to the button

[orange]

Review the Similar Threads at the bottom of this page.

[June7]

I am rather confused by your description of form/subform arrangement. Not sure which form is on which form. If the other threads on same topic don't resolve issue, suggest you provide your file for analysis. Follow instructions at bottom of my post.

[dominik@kartony24.eu]

Thanks for help. I resolved my problem

[Welshgasman]

Thanks for help. I resolved my problem

Well, please explain how you have and also any code used to do it.
These forums are here to help others, so it might help someone else in the future, trying to do the same thing.