Transfer of data from one listbox to another.(Access97)

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

Guest

Hi
I got a situation here where i have two listboxes.say listbox1 is given data from a table.when i select an item from this listbox and press a button the item gets deleted from this listbox and gets added to the second listbox. the same should happen from the other listbox. i have executed this using a backup table as there is no additem and removeitem commands in Access. Is there any other simpler way by which i can execute this??
 
Add a field to the table that specifies which list the item should be in.
Use this value as a parameter in the query for the row source of each
listbox. When you click the button, change the value of this field for the
selected items and requery each listbox.

--
Wayne Morgan
Microsoft Access MVP


Bharath said:
Hi,
I got a situation here where i have two listboxes.say listbox1 is given
Click to expand...
data from a table.when i select an item from this listbox and press a button
the item gets deleted from this listbox and gets added to the second
listbox. the same should happen from the other listbox. i have executed this
using a backup table as there is no additem and removeitem commands in
Access. Is there any other simpler way by which i can execute this??
 
Back
Top