Open data

[Robert Couchman]

Hello, i am trying to use data from one form to input into
the next open form, what code would i need to use so that
when i click the button to open the new form, the customer
id and name will automaticlly be inserted.
**please note that the existing window cannot be closed**

Thank you,

Robert Couchman

 

[Bob Phillips]

Robert,

Here is one technique.

First load the form, without showing it, transfer the data, and then show
the form. Here is an example that transfers the contents of Textbox1 in
form1 to Textbox1 in form2

Load UserForm2
With UserForm2
.TextBox1.Text = TextBox1.Text
.Show
End With

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)