PDA

View Full Version : Transfering data form to form



bopo
01-13-2007, 10:34 AM
Hiya People :hi:

Jusr wondering how I can transfer data between forms, .e.g taking data from a text box and placing in into another text box on a form?

thanks.

lucas
01-13-2007, 10:51 AM
Guessing that you mean another textbox on a different form:

Me.TextBox1.Text = UserForm1.TextBox1.Text

bopo
01-13-2007, 11:44 AM
Thanks, looks like it works, however I want all the info to automatically appear on the new form, rather that clicking a button to display the information.

Would I need to use something like

Private Sub tTextbox1_AfterUpdate

or something similar?

mdmackillop
01-13-2007, 11:49 AM
Hi Bopo.
How are you opening the new form?
Data can be added to it using the Userform Initialize event. Do you anticipate entering data on the spreadsheet while a Userform is displayed?

bopo
01-13-2007, 12:05 PM
Hi Bopo.
How are you opening the new form?
Data can be added to it using the Userform Initialize event. Do you anticipate entering data on the spreadsheet while a Userform is displayed?

Erm okay....:doh:


Bascially a user in going to fill details into a form, such as name, costs etc, then a button on this form will be clicked, which will open a new form and display some of the details from the previous form for verication purposes and results of calculations will also appear on the form.

mdmackillop
01-13-2007, 12:43 PM
You could possibly use a multipage control on the form, rather than multiple forms.

bopo
01-13-2007, 12:46 PM
Anyway, I have put it behind a button, no problems. however anthoer question

I want to add data from 2text boxes into on another 1 lstbox, how do I do this?

mdmackillop
01-13-2007, 01:17 PM
Here's a simple example

new2006
02-07-2007, 11:08 AM
thanks