Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2006
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    List box and row source (Access 2000)

    Can you help me buld a list box based on 2 fields in one and the same table? .My list based is based on the query, but the items in the list box do not correspond to the items in the query,as could be seen in my form.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: List box and row source (Access 2000)

    The items in the list box are exactly the same as the items in the query, but while the query has 2 fields, you have set the Column Count property of the list box to 5. This should be 2. And you should specify only 2 widths in the Column Widths property, for example
    1.344cm;4.565cm
    (use , instead of . if the comma is the decimal separator on your system)

  3. #3
    2 Star Lounger
    Join Date
    Mar 2006
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List box and row source (Access 2000)

    Thank you so much ,Hans ! Now i have a sound list box with the full items in it

Posting Permissions

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