List 1 to list 2

[Drunkenneo]

I have a task here which i need a great help, i will try to explain in most suitable way,

I have list 1 where date and count of a file sent date and count of entries for the date appears, i want when i double click on item it should go to list 2 and disappears from list 1. and on clicking ok it should open form with file detailed entries from list 2. I think thats the simple way i could explain. :banghead::banghead::banghead::banghead:

 

[Drunkenneo]

Here is the image which missed from above post

 

[Drunkenneo]

Bump!!1Bump!!

 

[JHB]

One way to do it is:
Create 2 tables one for each list.
When you double click, append the data to the table for list #2, and then delete the data from the table for list #1.

 

[Drunkenneo]

I am quite sure this can be do without it also. however trying at my end..

 

[JHB]

If you think you know a solution go for it, good luck!

 

[stopher]

One way to do it is:
Create 2 tables one for each list.
When you double click, append the data to the table for list #2, and then delete the data from the table for list #1.

I guess you could use a single table for both lists and have a "List" column denoting 1 or 2. Then each list is filtered accordingly.

The when the user double-clicks, the code changes the list value for that record from 1 to 2 then just requeries both lists.

Chris

 

[David R]

Stopher's solution is definitely more robust.