Ok, great! You would put all this code in your destination form. This is going to be more "pseudo-code". The idea is this...When referencing an object on another form (text box, check box, combo box, etc...) you need to tell VBA where to look. So you start out with "Form" if it is a form, "Report" if it is a report, etc...You then need to tell it your form name, so "Form_Form1". From this point on you can reference the object just like you would on the native form. Form_Form1.Product_Name.Value. Now let's look at it in code...
Code:
Dim strProdName as String, strInternalRef as String
strProdName = Form_Form1.Product_Name.Value
strInternalRef = Form_Form1.Internal_Reference.Value
txtProdName.Value = strProdName
txtInternalReference.Value = strInternalRef
The txtProdName and txtInternalReference will be your text boxes on Form2. If you want the data to be brought over when the user clicks a button you should put this code in the "On Click" event. You can also set your local objects equal to the value of your "foreign" objects directly.
Code:
txtProductName.Value = Form_Form1.Product_Name.Value
I just prefer to assign to variables first. Keep in mind I defined all my variables as String for this example. You may need to define them as Integer, Long, etc...If you data type(s) is/are different. I hope this helps!