ACC2003: Last Row in Listbox not visible

[Herman]

I have a form with two listboxes, and I want to move items from one listbox
to the other. I have found some -perfect- code to move the items on
http://support.microsoft.com/kb/278378.
However, if I move an item from the left to the right listbox, the item is
not shown immediately in the right listbox. I have to click on another
control before the listboxes is updated and the newly added item is
displayed. I am using Access 2003. Listbox.requery or form.requery won't
help. Any suggestions?

 

[Stuart McCall]

I have a form with two listboxes, and I want to move items from one listbox
to the other. I have found some -perfect- code to move the items on
http://support.microsoft.com/kb/278378.
However, if I move an item from the left to the right listbox, the item is
not shown immediately in the right listbox. I have to click on another
control before the listboxes is updated and the newly added item is
displayed. I am using Access 2003. Listbox.requery or form.requery won't
help. Any suggestions?

You could save yourself some work and use this instead:

http://www.smccall.demon.co.uk/Downloads.htm#TwinList

A ready to import solution which does exactly what you want, from the sound
of things.

 

[Herman]

Thank you, Stuart. Nice example, but I am not sure about how to get my form
and the example to work together. I am using an unbound form, with a subform
and two listboxes (available and selected). When browing the subform
(containing e.g. Countries), a multi-column listbox (containing all available
players) will be updated. From that "Available" listbox, I would like to
select some players for further processing. I almost got this to work, except
for the refresh of the "Selected" listbox. However I have some problems
converting your solution to a "multi-column listbox" solution and getting it
updated. Any suggestions?

 

[Stuart McCall]

Thank you, Stuart. Nice example, but I am not sure about how to get my
form
and the example to work together. I am using an unbound form, with a
subform
and two listboxes (available and selected). When browing the subform
(containing e.g. Countries), a multi-column listbox (containing all
available
players) will be updated. From that "Available" listbox, I would like to
select some players for further processing. I almost got this to work,
except
for the refresh of the "Selected" listbox. However I have some problems
converting your solution to a "multi-column listbox" solution and getting
it
updated. Any suggestions?

<SNIP>

I'm afraid my twinlist won't cope with multiple columns, at least not
without extensive reworking. Essentially what's needed is to convert it to
using a recordset to store the list's values instead of arrays as it does
now.