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

B

Bharath

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??
 
W

Wayne Morgan

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??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to retrieve data from unbound listbox. 2
transfer data from one listbox to another 2
Listbox Delete multiple items 1
how to work with all items in a listbox 1
Listbox Output to Individual Listboxes 0
Sorting a listbox when items are added 4
ListBox error "Invalid argument" 3
cascading listbox in word vba userform 0

Top