Numbers deleted reappear (1 Viewer)

[JPaulo]

Hi all;

I need to sort the 60 numbers of the listbox and delete one by one, but the numbers deleted reappear.

Any idea, please ?

 

[missinglinq]

I'm guessing you mean that after closing the form and then subsequently re-opening it, all the "deleted" numbers are back, which is the way you example you posted worked. That's because the RemoveItem (and AddItem) only affects the RowSource until the form is closed. When it re-opens the RowSource is as listed in the Properties Pane. You can only change this in Design View.

If you want to permanently deleted the values you'll have to base your ListBox on a table and actually delete the valuse from the table, then Requery then ListBox.

 

[JPaulo]

Thanks for responding.

Is not,

I want to anyway as it is, but during the drawn numbers appear already excluded and those I do not want to randomize more equal numbers.

I am looking for help.

 

[JPaulo]

Help me please.