Passing value from on form to another

[oakoen]

I have searched and tried and searched and tried to get this but just can't get it to work.

Form1 has a field of customer name
Form2 also a field of customer name
I would like to open form2 with the same customer name that I was viewing in form1.

Help?

I am new to vba. I have done some modifying of items and such by poking around, viewing working items then changing another trough trial and error, but I do not a working knowledge of it.

 

[Uncle Gizmo]

I believe the button wizard will offer you the option of going to a particular record if you select creating a button to open a form with the wizard.

 

[mcmichael13]

try this...
while in design mode on form2...
in the text box for Customer Name type:

=[Forms]![form1]![CustomerName]

where "form1" is the name of the first form, and "CustomerName" is the name of the text box where the Customer Name is displayed on form1.

i hope that makes sense, if i'm correct when you return to form mode, and open form2, it should display what you had for the CustomerName from form1 in form2.

 

[oakoen]

try this...
while in design mode on form2...
in the text box for Customer Name type:

=[Forms]![form1]![CustomerName]

where "form1" is the name of the first form, and "CustomerName" is the name of the text box where the Customer Name is displayed on form1.

i hope that makes sense, if i'm correct when you return to form mode, and open form2, it should display what you had for the CustomerName from form1 in form2.

Thanks. Works great, but I forgot to mention I need the Customer name field thats being carried over to be saved in company name field to the table of form2's record source.

 

[mcmichael13]

bound or unbound form?

 

[oakoen]

They are bound

 

[Uncle Gizmo]

I thought this question had been answered, seems not....

More Info Here:
Transfer Variables
Opening Form and Passing Variables
Repost: How to dynamically change field data source on a form