Calling a New Form and auto populating the text fields

[thebadger]

I have two user forms - one of which enables the user to search for a particular item. Providing this item is found (using find) I would like to be able to then show another form - prepopulated with information relating to items searched upon in the first form.

I have some code which ensures the 'search' item is found - this then calls the next form using form2.show. I was then going to assign values to the text fields using the activecelloffset comand based upon the cell found in the first form.

My problem is that I can call the second form but I cannot get anything to populate in the text fields.

I was wondering if these text fields need to be defined in the code of the first form - or if there is something to be added to an event procedure on the second from that will then show these values ?

 

[SIXTH SENSE]

Hi!
you may add this lines on the on activate event of the second form.

Form2.textbox1.text=someinfo1
Form2.textbox2.text=someinfo2
'and so on and so forth.

 

[parry]

Hi, you need to use the full object identifiers to the form your calling. So instead of TextBox1.Text put UserForm2.TextBox1.Text to identify that box. Use the Load statement to put the other form into memory then add the values to the boxes then show the form.

Private Sub CommandButton1_Click()
Load UserForm2  'put form into memory so boxes can be filled in
UserForm2.TextBox1.Text = ActiveCell.Value
UserForm2.TextBox2.Text = ActiveCell.Offset(0, 1).Value
UserForm2.TextBox3.Text = ActiveCell.Offset(0, 2).Value
UserForm2.Show 'show form
End Sub

 

[thebadger]

Thanks for your answers - much appreciated !!!!!!!!