Question: My ListBox (or ComboBox) are not showing the right new values.

Answer: You set up the ListBox correctly using an array for the RowSource, but whenever you change the data the ListBox is displaying you should send it a Requery() message:

select ... ;
   into array thisform.aList

thisform.lstTheList.Requery()