Hi there,

Would appreciate a solution on the following:

I have a form with two list boxes, the 2nd being populated with the result of a selection in the 1st listbox. A selection in the 1st triggers an autofilter to find the
items for the 2nd listbox.

Problem is that when the autofilter shows only 1 row following the header row, the row details are not shown in the 2nd listbox. When 2 or more rows are filtered there is not problem in populating the 2nd listbox .Part of the code is shown below:

Please Login or Register  to view this content.
Anything wrong with ranging the autofilter ?

Thanks - Eric