Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    38

    Unanswered: Send Data From Combo

    How can I send data that is selected from a combo box on a pop up form to a text box on a separate form?
    I can do it if the combo box and text box are on the same form using the following for the control source. (=[ControlName])
    Let me know if more information is needed and any suggestions are appreciated.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    If you use the after update event of the combo box on the pop-up form to something like:

    forms![MainForm]![txtTextBox] = me.[cmbComboBox]

    i.e. populate the textbox based on the behaviour of the combo box rather than have a control source for the textbox

  3. #3
    Join Date
    Oct 2003
    Posts
    38

    Smile

    Thanks, that worked.

  4. #4
    Join Date
    Oct 2003
    Posts
    38

    Question

    I figure since the above worked it would probably work in reverse, change the value of a combo box on a separate form from a text box but I haven't been successful. Should this work using the above?

Posting Permissions

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