Select a row in a listbox

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ppettit
    New Member
    • Mar 2008
    • 2

    Select a row in a listbox

    I generate a SQL string to populate a listbox
    eg.. Me.List36.RowSo urce = strSQL
    Me.List36.Reque ry
    (This is working OK)

    I have some code that will identify if a particular record exists.

    My question is can I have the identified record highlighted
  • ppettit
    New Member
    • Mar 2008
    • 2

    #2
    I found the answer Me.List.Selecte d(x) = True

    Comment

    • ADezii
      Recognized Expert Expert
      • Apr 2006
      • 8834

      #3
      Originally posted by ppettit
      I generate a SQL string to populate a listbox
      eg.. Me.List36.RowSo urce = strSQL
      Me.List36.Reque ry
      (This is working OK)

      I have some code that will identify if a particular record exists.

      My question is can I have the identified record highlighted
      Once you determine the Item's Row Position:
      [CODE=vb]'to select the 5th Item in the List Box (Rows indexed at 0)
      Me![List36].Selected(4) = True[/CODE]

      Comment

      Working...