Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    100

    Unanswered: Corresponding Listbox selection

    Hello all,

    Minor question that I'm hope has a minor answer.....

    I have 2 independent listboxes from the same table. When the user clicks on the first listbox I would like the corresponding row to highlight in the second listbox (a different field from the same table).

    Me.MonthlyEnd.*********= Me.MonthlyStart.ListIndex

    I'm assuming that I'm missing something in the above statement?

    Also, the reason I am not widening the listbox to hold both fields is because they will sometimes be different.

    Thanks!

    Norm

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Answer: Value

    Assuming that the matching column is the 1st ...

  3. #3
    Join Date
    Jan 2004
    Posts
    100
    Originally posted by M Owen
    Answer: Value

    Assuming that the matching column is the 1st ...
    Unfortunately, I wasn't able to get it to work. I think value may assume that the corresponding row would have the same value.

    The user will be clicking on an item in one listbox (MonthlyStart) and I would like the item in the same record to highlight in the other listbox (Monthly End).

    Any ideas?

  4. #4
    Join Date
    Jan 2004
    Posts
    100

    Solution

    Originally posted by norm801
    Unfortunately, I wasn't able to get it to work. I think value may assume that the corresponding row would have the same value.

    The user will be clicking on an item in one listbox (MonthlyStart) and I would like the item in the same record to highlight in the other listbox (Monthly End).

    Any ideas?
    The following is the solution:

    Me.MonthlyEnd.Selected(Me.MonthlyStart.ListIndex) = True

    .selected was the missing link.

    Thanks for the help.

    Norm

Posting Permissions

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