[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 & "'"
If Not Data1.Recordset.NoMatch Then
Text1.Text = Data1.Recordset![Name]
Text2.Text = Data1.Recordset![Department]
Private Sub Form_Load()
Text1.Text = Form1.Text1.Text
ooppss...the way i called form2 from form1 is: