List Box Problem!!!!

[Newguy28]

Hi Guys,

I have a list box in a form, that when you click on one of the options, its displayed in a text box. But what i want, is that when you click on a option in the list box its moved to the text box and deleted from the list box!!!

Is this possible and if so guys how can it be done???????

Thanks again in advance!!!

 

[Bat17]

Do you want it deleted from the underlying table or just hidden in the Listbox?
To hide it, you need toadd a yes/no field to the underlying table.
Adjust the Listbox so that it filters out the Yes field.
Then when you move the data to the text box you run an update query to set the new field to 'yes' and requery the Listbox.You will need to run another Update query to set the field back to 'no' to show the records again.

HTH

Peter

 

[Newguy28]

is there a simple way???