Passing textbox1.text (Form1) to textboxs.test (Form2) 2

[xhuck28x]

I am going nuts. I figured this would be so simple but I'm having no luck.

Form1 contains a textbox and a command button. when the command button is pushed, form2 is to open and populate a textbox with the value from form1.textbox.text.

what is the simple code for this and can this be done using the macro builder.

peace.

 

[AmritPaulSingh]

I don't know how to use macro builders but the code I'll use on clicking the command button is:

DoCmd.OpenForm "form2"
Forms!form2!textbox = Forms!form1.textbox

Or else you can write the "Forms!form2!textbox = Forms!form1.textbox" code on the onOpen Event of form2

 

[nice95gle]

Here is the Macro

The 1st action would be
OPEN FORM fill in the form name and you can figure out the rest

Then the next acion would be
SET VALUE
item = [Forms]![Form2]![Form2 TextBox Name]
expression = [Forms]![Form1]![Form1 TextBox Name]

 

[xhuck28x]

Great everyone....thankyou much!!!!!

peace.