You da man... thanks! 3 stars for you!
>Tommy,
>
>When you change the RowSource out from under a control like cbo and lst you need to call their .Requery() method so that they will repopulate themselves.
>
>>After a SQL select some data to the array, I show it in a combobox list.
>>
>>The first time, it shows just fine.... the number of array elements equals the combobox list drop down.
>>
>>But when I pick another value from a Source Table, and requery the SQL (by running the SQL statement again), and go back to the drop down list for aAd, it shows the new data.. but the combobox list has the same number of elements it did before (if the SQL is less in number, the bottom of the combobox list is blank... if the SQL is more in number, then the combobox dropdown still has the same number of elements as before, and the new SQL elements don't show).
Tommy Tillman A+ NetWork+ MCP