Clearing a listbox after record update

[Cdogg]

When I update the record on the form I would like to clear the list box. I can clear every thing but that.

Thank you for your help

 

[raindrop3]

Hello,

You can use the following code:

listboxname.RowSource = ""
listboxname.Requery

put this code in the 'update code', so if you press the update button, the listbox will be cleared.

Note: next time you open the form, you had to set the rowsource again. E.g.

listboxname.rowsource = "Customers"
listboxname.requery
You can place this code in the 'On-open event' of your form.

Greetings,

Albert

[This message has been edited by raindrop3 (edited 01-09-2002).]