Moving data between list boxes

[Bob Quintal]

=?Utf-8?B?UmVzdGxlc3NBZGU=?=

I have two list boxes: EndEquipmentList and ChosenList.

I would like to be able to populate data between the two list
boxes in a fashion not dissimilar to the form wizard pop-up. I
was going to assign the functionality to the doubleclick event
on each list box, but would be equally happy creating buttons
similar to the ones on the aforementioned form wizard.

I'm not very good at programming and am not sure how to
approach this. Do I need to create a table that will act as
the rowsource for the chosen list? The EndEquipmentList is
currently populated from a query. How do I remove items and
add items to this reflecting selections and unselections.

I'd appreciate any help.

Regards,
RA

Your current EndEquipmentList query is based on one or more
tables. Somewhere in your database is a table that stores the
indication of wheter or not the equipment is on the list or not.

The code to add the item to the endEquipmentlist must either add
the item to the table, if the presence of the item is what
determines inclusion, or change the flag to allow inclusion in
the query if that's how the query is filtered.

Code to remove the item deletes the row in the table or resets
the flag as applicable.

Please provide some further details, such as the SQL for the
EndEquipmentList query, and any other queries'SQL if they are
used in the creation of the EndEquipmentList query.

 

[Guest]

I have two list boxes: EndEquipmentList and ChosenList.

I would like to be able to populate data between the two list boxes in a
fashion not dissimilar to the form wizard pop-up. I was going to assign the
functionality to the doubleclick event on each list box, but would be equally
happy creating buttons similar to the ones on the aforementioned form wizard.

I'm not very good at programming and am not sure how to approach this. Do I
need to create a table that will act as the rowsource for the chosen list?
The EndEquipmentList is currently populated from a query. How do I remove
items and add items to this reflecting selections and unselections.

I'd appreciate any help.

Regards,
RA

 

[Guest]

I found a useful link that provides an overview of how to do this:

http://msdn2.microsoft.com/en-us/library/aa167285(office.11).aspx

Access Interfaces: Creating Paired Listbox Controls, Part 1

Have not been able to make it work yet, but this should do the trick.

Regards,
RA