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:
Anything wrong with ranging the autofilter ?
Thanks - Eric
Bookmarks