transfer data from one listbox to another

[Associates]

Hi,

I have a question in regards to adding items from a listbox to another
listbox in the Purchase Order form.

There are two Listboxes. One shows the whole list of items available in the
store and the other one shows only the items selected from the first listbox.

For example,

In the first listbox, there are four columns with the first one (ItemID) not
being shown in the listbox as follows

Name Price Unit
Introduction of Maths $30 each
Biography 1A $79 each
...

There is a "Add Item" button. What this does is to add the item selected
from the first listbox to the second one.

The idea of this is to let user know what items they have selected.

What i have got so far is it puts just the ItemID to the second listbox when
the button is pressed (which makes sense because the bound column is 1 - that
is ItemID). My question is whether there is a way of putting the items across
with the whole information just as seen in the first listbox.

I use Access 03.

Any help would be greatly appreciated.

Thank you in advance

 

[banem2]

Hi,

I have a question in regards to adding items from a listbox to another
listbox in the Purchase Order form.

There are two Listboxes. One shows the whole list of items available in the
store and the other one shows only the items  selected from the first listbox.

For example,

In the first listbox, there are four columns with the first one (ItemID) not
being shown in the listbox as follows

                 Name                       Price        Unit
   Introduction of Maths         $30          each
        Biography 1A                   $79          each
                   ...

There is a "Add Item" button. What this does is to add the item selected
from the first listbox to the second one.

The idea of this is to let user know what items they have selected.

What i have got so far is it puts just the ItemID to the second listbox when
the button is pressed (which makes sense because the bound column is 1 - that
is ItemID). My question is whether there is a way of putting the items across
with the whole information just as seen in the first listbox.

I use Access 03.

Any help would be greatly appreciated.

Thank you in advance    

Make RowSource of second ListBox based on the table as the first
ListBox and change ColumnCount, ColumnWidths to show desired data.

Regards,
Branislav Mihaljev
Microsoft Access MVP

 

[Associates]

Hi Branislav Mihaljev

Thank you for your reply.

Quote

Make RowSource of second ListBox based on the table as the first
ListBox and change ColumnCount, ColumnWidths to show desired data.

If i make RowSource of the second ListBox based on the table as the first
ListBox, it actually shows the whole records as the first ListBox (this is
not what i desired to have). I suppose what i was aiming at was to show in
the second ListBox a list of items that's been selected from the first
ListBox.

Hope I explained it well.

Thank you in advance