clear listbox when record refresh

[alvincgp]

I have a listbox in a form that is NOT bound to any table and how can I delete the listbox when I refresh my record?

 

[arnelgp]

to blank the listbox:

me.list0=""

to delete each element:

for i = me.list0.listcount-1 to 0 step -1
me.list0.removeitem(i)
next

 

[isladogs]

Just to clarify, which of the following do you mean
1. clear the selection(s) made
or
2. delete the contents of the listbox

What type of listbox - single or multiselect? Is the row source a value list?

 

[alvincgp]

in this form, I have a vba for selecting files outside access as attachment in outlook. the files selected will be input in the listbox.

I do not need the files to be recorded in the access, so whenever a user click for next or new record the listbox shall be cleared.

the listbox is a value list.

 

[alvincgp]

hi arnelgp,

my refresh button is built with embedded macro on the On Click event.

is there anywhere I can code the vba the listbox event?

 

[arnelgp]

create a public function in a Module

public function fnClearList(Byref lst As Listbox)
Dim i as integer
for i = lst.listcount-1 to 0 step -1
lst.removeitem(i)
next
end function

on the embedded macro Runcode your pulic function:

fnClearList([listboxNameOnTheForm])

 

[alvincgp]

thank you soooooo much!!!!

 

[arnelgp]

you're welcome.