Moving data between list boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RestlessAde - 13 Jul 2007 20:14 GMT

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

Reply to this Message

Bob Quintal - 13 Jul 2007 20:04 GMT

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

> I have two list boxes: EndEquipmentList and ChosenList.
>
[quoted text clipped - 14 lines]
> 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.

Signature

Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Reply to this Message

RestlessAde - 13 Jul 2007 20:48 GMT

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

> I have two list boxes: EndEquipmentList and ChosenList.
>
[quoted text clipped - 12 lines]
> Regards,
> RA

Reply to this Message