Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    ID
    Posts
    2

    Post Unanswered: Populating VBA Listbox in Access

    I am attempting to populate a listbox on an Access form using elements of a collection. I can populate the listbox fine using the .RowSource property of the listbox. However, I cannot select the items from the listbox. I can't even get the On_Click event.

    I previously was able to get this working using the elements of a recordset. Once I switched to a collection, I was shot down.

    I have the Row Source Type property set to Value List on both, Column Cout to 1 and Bound Column = 1.

    Any ideas?

    Thanks.

  2. #2
    Join Date
    Aug 2002
    Location
    ID
    Posts
    2
    Found it, finally!! I had the .AllowEdits property of the parent form set to no!

Posting Permissions

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