Results 1 to 3 of 3

Thread: Newbie VBa Pls help

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2005
    Posts
    5

    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.

  2. #2
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    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:
    1. 'This populates a textbox named Text1 on the 2nd form with the value from
    2. 'a textbox also called Text1 on the first form.
    3. 'This assumes Form1 is still open when you open Form2, although it could be
    4. 'hidden or minimized. If Form1 is closed, you'll have to save the values you
    5. 'want in global variables or by some other means.
    6. Private Sub Form2_Open()
    7.     Me!Text1.Text = Forms!Form1!Text1.Text
    8.     'etc
    9. End Sub
    Tengo mas preguntas que contestas

  3. #3

    Thread Starter
    New Member
    Join Date
    May 2005
    Posts
    5

    Thumbs up 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
  •  



Click Here to Expand Forum to Full Width