Populate field from previously entered name

[paulcraigdainty]

I have a form with a text box that the user enters their name into. When they click submit a menu form is opened. I want the name that was entered to be carried over to a field on the menu form. This will welcome the user, eg: WELCOME John Smith.

Im thinking that i should use the INSERT INTO function, but im not sure of how to go about it.

 

[RichO]

If the original form is still open you can set the control source of the textbox in the menu form to:

=[Forms]![NameOfForm]![Person'sNameTextbox]

 

[paulcraigdainty]

that worked fine, thanks