[SSSSSS]

I have Form 1 and Form 2 connected using module

In Form 1 I have a text box for the user enter the name.

I need to display that name in the title bar in form 2.

How can I do that?

ssssss

[Keithuk]

You can do this a couple of ways.

1. Because you're using a module make a variable.

Public UserName As String


Form 1

Private Sub cmdNextForm_Click()

UserName = Trim$(txtUser.Text)
Form2.Show
Unload Me

Exit Sub

Form 2

Private Sub Form_Load()

Me.Caption = "Welcome " & UserName

Exit Sub

or

2. Just put the name in the titlebar before you show the form.

Form 1

Private Sub cmdNextForm_Click()

Load Form2
Form2.Caption = "Welcome " & Trim$(txtUser.Text)
Form2.Show
Unload Me

Exit Sub

[moronovich]

How about this one:

Code:

//Module1.bas
Public nextForm As Form2

//Form1:
Private Sub cmdNextForm_Click()
userName = Trim$(txtUser.Text)
Unload me
Set nextForm = new Form2
Load nextForm
With nextForm
       .caption = "Welcome " & userName
       'Set other properties here
End With
nextForm.show
End Sub