Requery listbox from a listbox

Joel · Oct 6, 2005

How do you requery a multiselect listbox from another multiselect listbox?
I have tried docmd.List2.requery afterupdate and it doesnt work but the
query works, it just wont update the listbox.

If i use a combobox afterupdate to set the peremiter and requery, it works
fine.

Im stumped, any ideas?

Thanks
Joel.

Allen · Oct 6, 2005

Joel,

Another thing to try that I have used successfully is:

lstBox.RowSource = lstBox.RowSource

Very simple, but it has the effect of requerying the listbox.

For examples of requerying listboxes within VBA code, see the tools at
http://www.aislebyaisle.com/access/tools3.htm

Joel · Oct 7, 2005

Thanks a bunch Allen.

lstBox.RowSource = lstBox.RowSource worked great.