Load new form and set textbox value... ACCESS AND VBA

[Icelizard]

ACCESS AND VBA

I have 1 form lets call it Form1 which has a text box called say textBox1(along with many other form components), the will find record they want and then click a button, which i want to open a new different form (Form2) and set a text box on that form (textBox2) to the value of the textBox in Form1.

Dim tmp As String
tmp = VolunteerID.Value

DoCmd.OpenForm "Comment", acNormal, , , acFormAdd, acWindowNormal
DoCmd.GoToRecord , , acNewRec
'To obtain that varibale was read.
MsgBox (tmp)
'Not sure if this is needed
'VolunteerID2.SetFocus
VolunteerID2.Text = tmp

Cheers for any help

 

[PHV]

DoEvents
Forms!Comment!VolunteerID2.Value = Me!VolunteerID.Value

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Icelizard]

lol cheers, it was that simple!