[Originally posted by maria]

hello there :)

my problem is i want to pass value (which is user Name) from text1.text in Form1 to text1.text in Form2.

well, i can do this only for the first user.

When a first user, for an example Adam put his name in text1 in form1,his name will appear in text1 in form2. i'm success in this. But, my problem is, when the second user (Eva) put her name in text1 form1, her name did not appear in text1 form2 because Adam's name still appear in the text1 form2.

Why this is happen? why the text1 form2 did not show Eva's name?
Could anybody tell me why?
i'm using MSAccess 97 as my database

Thanks in advance!

below is my coding.

Private Sub Form_Activate()
Dim Log as string

Log = "Name='" & Text1.Text & "'"
Data1.Recordset.FindFirst Log
If Not Data1.Recordset.NoMatch Then
Text1.Text = Data1.Recordset![Name]
Text2.Text = Data1.Recordset![Department]

End If

End Sub
Private Sub Form_Load()

Text1.Text = Form1.Text1.Text

End Sub


ooppss...the way i called form2 from form1 is:

load Form2