Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sending values to popup fom (MSACCESS2003)

    I have a mainform which has a listbox on it. Form1, List1. On clicking the list I have a popup form, Form2. Whats the best way to get the listbox value on Form1 into a textbox on Form2 (Popup) I was thinking of doing public variables, is that the best way or are there other syntax methods. Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sending values to popup fom (MSACCESS2003)

    Should the user be able to edit the text box on Form2, or is it fixed?

  3. #3
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sending values to popup fom (MSACCESS2003)

    Thanks Hans, yes the texbox text will be edited although it will be then put in a file with its own code. Hope that makes sense.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sending values to popup fom (MSACCESS2003)

    You can put code in the On Load event of Form2:

    Private Sub Form_Load()
    Me.Text1 = Forms!Form1!List1
    End Sub

    Substitute the correct names.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sending values to popup fom (MSACCESS2003)

    Many thanks Hans, did not realise I could do that. Best regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •