Reading from form to subform RRS feed

  • Question

  • Hi!

    I have a form with a listbox which has values from a query. 

    Then, I have a subform in which I would like to display the value selected from the listbox in the form. But I don't know how?

    I tried:

    subform.textbox.text = [form]!list22.value (I have also tried itemdata and itemselected but didn't work either)

    Any one can help, please?

    Monday, May 7, 2018 6:27 PM

All replies

  • Use the listbox's AfterUpdate event.
    Me.mySubForm.Controls("mytextbox") = Me.myListbox
    But it bothers me that you have a value on your main form that you are copying to your sub. Normally, you don't want data in one table that is dependent on the data in another table. Can you explain the requirement that you are trying to meet?

    Bill Mosca

    Monday, May 7, 2018 6:42 PM