From one listbox to another listbox

[scopes456]

I have a form where i would like users to select information from listbox1 ( its source comes from tbl_task) and move it to listbox2 where that information can be save in tbl_daily_task. I only need two command button, one to move the items from listbox1 to listbox 2, and one to remove items from listbox2 if they make a mistake.


I found many examples of how to move items from one listbox to the other, but i was not able to make it work.Some require DOA reference and ACODB.And i could not get any to work,

Help Please

 

[Grumm]

I've attached an example of how I would do it.
(Some here would probably have a beter way to get the selected data.)

You can add as many tasks as you want. You can modify the code to block tasks that are already in the list if you want.

Hope that will help you see how DAO works.

 

[Grumm]

Agree, but maybe someone has a method that is faster or less complicated.
I'm not an expert in access. So this is the same example but with a more optimized code.

 

[scopes456]

Grumm Thank you very much, that is the idea how i wanted to work. One thing i notice it does let me go to a New record. For example today i select Work, And Lunch. Tomorrow i would like it to be blank to select new items, But i also want it to keep record of the items from today. I tired making a form to go to new record, but would not allow me

 

[Grumm]

Can you show us what you already have made ?
If you want to save this for each day, you must change the database structure.
New column to store the date of entry, show only the tasks of today.

 

[scopes456]

Grimm this is what i have so far

 

[Grumm]

Ok.
So what you want is that you add tasks on a specific date and save it ? Is that correct ?
Let me know what you need and i can help you out.

 

[jdraw]

Here is a free video tutorial from DataPig that deals with moving values to/from 2 listboxes.