|
-
May 17th, 2005, 02:20 PM
#1
Thread Starter
New Member
Newbie VBa Pls help
I am trying to select certain fields from an access form and launch a new form within the same database with certain same fields populated from the last.
Please can you advise on what code procedures would be used as a template. Am a complete newbie so specifics would be helpful.
Ta.
-
May 18th, 2005, 02:21 PM
#2
Frenzied Member
Re: Newbie VBa Pls help
In the open event of the 2nd form, populate the controls on that form from the controls on the first form.
VB Code:
'This populates a textbox named Text1 on the 2nd form with the value from
'a textbox also called Text1 on the first form.
'This assumes Form1 is still open when you open Form2, although it could be
'hidden or minimized. If Form1 is closed, you'll have to save the values you
'want in global variables or by some other means.
Private Sub Form2_Open()
Me!Text1.Text = Forms!Form1!Text1.Text
'etc
End Sub
Tengo mas preguntas que contestas
-
May 25th, 2005, 12:54 PM
#3
Thread Starter
New Member
Re: Newbie VBa Pls help
Thanks,
soz for delay, however away for few days.
I'm assuming that this is repeated for all fields. Will try and confirm working.
Cheers.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|