>I have a listbox on my form. The RowType is 5 (array). My problem is that based on certain criteria the RowSource can change. So, I change the RowSource and Requery but once I have changed the source the Listbox always remains blank. When I look at the RowSource while the form is running it does change the RowSource but the display doesn't work. What am I missing?

I assume that new RowSource is also array. Is it possible that new array isn't visible to listbox because it's local? BTW, it'should work w/o requery().