Move items from Listbox to other listbox

[SeBasTiaan]

Hello everybody,

Hopefully somebody can help me on this one. I searched the whole internet and access forums, but I didn't find the exact solution for my problem.

I've got a table with students, a table attendance, where I now only save the students who are absent, but I would like to save also the students who are PRESENT (at the same time).
I've got a combobox where I filter the Class, which then updates a listbox with the students from that class. What I do now is select the students from the listbox and then press a save button and it saves the records to the table absence with STATUS: ABSENT.

I would like to save the NON selected students also in that table, but with PRESENT in the column STATUS.

I thought of making another listbox next to it, where after selecting the absent students, they wil apear and disappear in the PRESENT table so I can store all the information.
But the only problem is that I can find this solution when the listbox is populated by a list of values instead by a table or query. And the other solution is to store the temporary data into 2 different tables, but that's not working for me because it's a multi user database and everything will be messed up.

Hope that someone can help me, I will be very happy.

 

[Banana]

Look up my thread about same topics. Click Me.

 

[SeBasTiaan]

not exactly

Thanks Banana, but in this example it uses another table to store the selected data, and that's just what I don't want, because it's a multi user database.

My current listbox updates an txtbox with the ID's selected in the multi select lixtbox. If it's possible to store the NON selected items in another txtbox, that would also solve my problem.

any more suggestions?

 

[SeBasTiaan]

Example database

Maybe somebody can help me with this, I added a sample database of how it should be.

All items should be saved in the attendance table (Present and Absent)

Hope you guru's can help me on this one.

 

[Oldsoftboss]

This cut down example is one from a Db that came with a book I bought once. The code was waaaay to deep for me, I used the table example mentioned above, as you can use the table as a temp table and the results into reports etc a lot easier. I simply delete all the records in the table when the form closes.

Dave