Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2010
    Location
    California
    Posts
    15

    Unanswered: Text Box Control Source Dynamically changes based upon selections in list boxes

    Hello,
    On a tabbed form I have 5 listboxes.
    Is it possible to have a Text Box that becomes populated and dynamically changes so that when I click in any of the four listboxes on any of the rows the most recent clicked selection populates the "Text Box"?

    The names of the list boxes are...

    ListBoxMisc
    ListBoxEST
    ListBoxENF
    ListBoxINTER
    ListBoxFPM


    The name of the Text Box to be populated is "Title". I am using Access 2003

    If this is possible how would I do this? I am not familiar with vba all too much.

    Your help is appreciated!


    Iram/mcp
    Iram/mcp

  2. #2
    Join Date
    Oct 2009
    Posts
    340
    yes; in the AfterUpdate Event of the list box you would put your code:
    me.TextBoxName = me.ListBoxName.column(x)

    enter your actual names for each, and the x means which ever column if the list box has multiple fields. (keep in mind that I believe in 03 the column count begins with 0...though could be wrong on this point)

    hope this helps.


    www CahabaData com

  3. #3
    Join Date
    Sep 2010
    Location
    California
    Posts
    15

    Smile me.TextBoxName = me.ListBoxName.column(x)

    NTC, You are the man!


    Awesome it worked!



    Thanks.
    Iram
    Iram/mcp

Posting Permissions

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