ACC2003: Last Row in Listbox not visible

  • Thread starter Thread starter Herman
  • Start date Start date
H

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?
 
Herman said:
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?
Click to expand...

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.
 
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?
 
Herman said:
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?
Click to expand...
<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.
 
Back
Top