>>Hi Paul,
>>
>>>Got another c0000005 error. It happens everytime the code changes the rowsource of a listbox. This code works at 90 sites but not this one.
>>
>>Try setting the RowSourceType to 0 before you change the RowSource and reset it afterwards.
>>
>>Christof
>
>Hi Christof,
>
>Thanks for the suggestion but no luck. Still open for suggestions.
>
>Paul
What if you will blank RowSource property itself (before change) and restore it afterwards? Also, note that you should issue List.Requery after each rowsource change.
Edward Pikman
Independent Consultant