Paired List Boxes

L

Larry

I have never developed paired list boxes but I am in a situation at work that
requires a paired list box. I am unsure of how to program the command
buttons to move over my multiple selections or single selections which ever
is easier to the selected box.

For example, I have one list box that lists all 50 states and all the
countries and provinces througout the world. I need to move over those that
I select in the available list box to the selected list box when I click on
the command button. Also, I need the flexibility to move items that I did
not intend to select from the selected list box back over to the available
list box.

Any Assistance would be appreciated. Thank You.

Larry
 
L

Larry

Doug,

I am unable to download the version listed on the website. I am on a gov't
system and cannot alter the applications loaded. Please advise.
 
D

Douglas J Steele

You mean you cannot download files? That's all that is: no installation
involved.

While it's not difficult to do what you want to do, it can be complicated to
explain!

The easiest approach would be to have a "Selected" flag on your table, and
have one of the listboxes show all of the rows for which Selected is False,
and the other one show those rows for which it's True.

As you move rows from one list to the other, change the value of Selected,
and requery both listboxes.
 
Top