Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chatham, Ontario, Canada
    Posts
    86
    Thanks
    5
    Thanked 1 Time in 1 Post

    combo box list (97)

    I have a combo box which is designed to present a subset of the client's inventory. They pick a category and subcategory then pick from the list. The Row Source is set to:
    "SELECT DISTINCT Inventory.[Item Number], Inventory.Description FROM Inventory INNER JOIN tblItemCatSubcat ON Inventory.[Item Number] = tblItemCatSubcat.[Item Number] WHERE [tblItemCatSubcat].[Category] = '" & Me![InvCategory] & "' AND [tblItemCatSubcat].[Sub Category] = '" & Me![InvSubCategory] & "' ORDER BY Inventory.[Item Number]"

    This exact setup has been working for several years (and continues to) on other forms but on a new one recently created a peculiar thing happens. The length of the displayed list is limited to the number of list rows quite without regard to the substantially larger number of records which the query will return.

    If I scratch my head any harder there will be no hair left. Any pointers will be greatly appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: combo box list (97)

    Sorry, but I am not clear on your problem. What is your list rows setting for the combobox? That is what controls the length of the list, not the number of rows returned in the row source.
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chatham, Ontario, Canada
    Posts
    86
    Thanks
    5
    Thanked 1 Time in 1 Post

    Re: combo box list (97)

    I shouldn't have rushed that question out then gone on vacation. Lets see if I can be a little clearer.
    The row source query is created by two other combo boxes on this form.
    The user selects a category from about 60 in cb1. She next selects a subcategory from a list in cb2 determined by cb1. There could be up to 19 in cb2. Both of these boxes work properly with list rows set to 8.
    The query created after cb2 should (and does as a query) return 50 items but if the list rows value is 8 then there will only be 9 items instead of 50. Sometimes re-selecting the same item in cb2 will increase the number in the box in question but it will only show the correct number of items if there are fewer than list rows plus 1.If the number of list rows are increased the number of lines returned is the new value for list rows plus 1.

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

    Re: combo box list (97)

    Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chatham, Ontario, Canada
    Posts
    86
    Thanks
    5
    Thanked 1 Time in 1 Post

    Re: combo box list (97)

    Edited by HansV to attach zip file to post instead of using external link. (Internet Explorer has no problems with it)

    Here is the offending form. The only category is IMF Pipe Components and the only subcategory is Angle Rings. It seems that the lounge doesn't work with Opera.

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

    Re: combo box list (97)

    It works fine for me, but...

    You have set both the Column Widths and the List Width for both combo boxes to large values: 15 cm for InvCategory and 10 cm for InvSubCategory. If the list contains more then List Count items, a scroll bar is displayed on the right hand side of the list, but depending on the screen resolution and the position of the form, the scroll bar may be offscreen, making it seem as if the drop down list is limited to List Count items.

    Try smaller values for the Column Widths and List Width properties.

Posting Permissions

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