how to add an item from one list box to another??

[tara99]

one listbox1 displays information from one table1, listbox2 displays information from another table2.
I want to add an item from listbox2 to listbox1 using a button. (table1 will be effected, table2 stays the same )

How can i do this.

please help?

[Killer42]

one listbox1 displays information from one table1, listbox2 displays information from another table2.
I want to add an item from listbox2 to listbox1 using a button. (table1 will be effected, table2 stays the same )

How can i do this.

please help?

I'm not expert in this area, but I'd guess what you will need to do behind the button is copy the record from table2 to table1, then use "ReQuery" on listbox1.

[tara99]

I'm not expert in this area, but I'd guess what you will need to do behind the button is copy the record from table2 to table1, then use "ReQuery" on listbox1.

can you clarify this abit.

I have two list boxes.
Listbox1 holds some data from query of table1 for a particular selection of the combobox.
listbox2 holds also some data from table2 independant of any selection.

What I want is that when I select an item from listbox2 and hit the OK button, it should be displayed in the listbox1(appened), also those item should also be added into the table1 for that particular selction from combobox.

Can you help

[MMcCarthy]

can you clarify this abit.

I have two list boxes.
Listbox1 holds some data from query of table1 for a particular selection of the combobox.
listbox2 holds also some data from table2 independant of any selection.

What I want is that when I select an item from listbox2 and hit the OK button, it should be displayed in the listbox1(appened), also those item should also be added into the table1 for that particular selction from combobox.

Can you help

Tara you can't do this as listbox1 is based on a query. Normally to add something to a listbox you have to add it to the relevant table in the query. Then requery the listbox.

What are you trying to do and why is just as important as the physical action you are trying to code. Explaining that will get you a more accurate answer than I want to move something from one listbox to another. It's hardly ever that simple. So explain your thinking and we'll take it from there.

Mary

[andy1534]

For i = 0 To lst1.ListCount - 1
If lst1.Selected(i) Then
lst2.AddItem lst1.Column(0)
End If
Next i

[Killer42]

For i = 0 To lst1.ListCount - 1
If lst1.Selected(i) Then
lst2.AddItem lst1.Column(0)
End If
Next i

Hi andy. Just a quick tip on posting, for future reference. If you want the indenting to work (it can be really frustrating the way it just disappears, huh), you have to put [c o d e] tags around your code. Like this...

For i = 0 To lst1.ListCount - 1
  If lst1.Selected(i) Then
    lst2.AddItem lst1.Column(0)
  End If
Next i