combo box list (97)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

Could you post a stripped down copy of your database? See post 401925 for instructions.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote