MS Access - AutoSelect Listbox item-VBForums
Results 1 to 1 of 1

Thread: MS Access - AutoSelect Listbox item

  1. #1

    Thread Starter
    eltiT resU motsuC Static's Avatar
    Join Date
    Oct 2000
    Rochester, NY

    MS Access - AutoSelect Listbox item

    I must be getting rusty.....

    I have 2 listboxes,

    1 Accounts
    1 Reasons

    after selecting an account it loads the reasons... I want the first row of reasons auto selected so the listindex is set

    I tried

    lstReason.ListIndex = 0

    which works, but the the lstAccounts does not keep the line selected to show you the account you chose.

    so I tried

    lstReason.Selected(0) = True

    while this also does work... it seems to goof up after a few account selecttions!?? it "locks" into the lstAccounts... so you cant click into one of the textboxes... seems to re-trigger the lstAccounts_Click event if I click anywhere else. So then, if i hit a key... it jumps in the lstAccounts then they unlock again.


    EDIT: ok to make things even more confusing - it seems that it is dependant on what data is in the lstReason??????????
    ones that have EXP_PLAN break... ones with NO_RPLAN are fine?
    I AM LOST.... how can data effect the actual control?
    Last edited by Static; Oct 30th, 2007 at 03:50 PM.
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

Posting Permissions

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


Click Here to Expand Forum to Full Width