select list box record to populate different table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have got an SQL that runs into a list box for results, then i would like to
select some of the records in the list box to be added into a different table
in a subform..
 
Look in Access help for the ItemsSelected property. The example there shows
you how to loop through the selected items and perform some action. You'd
then have to use the listbox's ItemData or Column property to get the value
and do a table insert for each item.

Barry
 
ItemsSelected is a property of the ListBox control. It returns all the items
currently selected. Look in help for the listbox control and then the
ItemsSelected property.

Barry
 
Hi.. Thanks Barry.. thanks for the patience...

I found the help.. I was looking from the Access Database help itself,
whereas i should be looking from the coding page help.. which is totally
different..

anyway.. the example shown is still not very clear and i don't really
understand.. maybe being a first timer.. has more difficulty in understanding
this..

let me give you a clearer picture..

my form name is Trans_record, the listbox name is :list_trans, and there is
another list box that i want to put the record selected into is called
:Selected_trans.

the list_trans has 9 columns and i have change the bound column to 0.

now.. in List_trans, i have used SQL to union 2 tables of records into this.

I would like to have the user select the records they want. To do this. the
user do a double click on the record itself, and it should be listed in the
2nd listbox, "Selected_trans".

After the user are satisfied with their chosen records, then i would have a
command button to process the selected records in the "Selected_trans" list
box.

so how should i code it..???

your help in this is greatly appreciated.

thanks in advance.
 
Back
Top