Move records from listbox to listbox (like a wizard)

[craig1988]

Hi all

I have found a couple of different examples of what I am looking for but none have has everything I need. Hopefully someone can point me in the right direction.

I have a form with 2 listboxes (lstOne, lstTwo) & 4 cmdbuttons (cmdMoveSingleOneToTwo, cmdMoveAllOneToTwo, cmdMoveSingleTwoToOne, cmdMoveAllTwoToOne). I have a table with the records I want to pick and chose from (tblFields which has fldID, fldVal, fldDesc)The database will be used by multiple users so adding a bolean (Yes/No) is not an option. I presume I need to load the records up into a dynamic recordset as any user opens the form???

Anybody got any ideas?



Thanks

[orange]

You may find this older free video by Datapig useful

[craig1988]

I don't think that is a suitable approach? the data in the table cannot be edited as there may be multiple users editing the list boxes. The records in the list boxes must be unique record sets created by each user as they open the form.

The record set will be a copy of the records within the table but the actual records within the table should not by used in the list boxes.

This is why I assume I have to use recordsets??

[ssanfu]

You have not said what you are trying to do with the form/list boxes/buttons. Yes, I know - move records between list boxes. but not really move them.

Is the dB split?
How static are the records in the table? If the dB is split, you could use a temp table in the FE.
How long do you need to keep the records in the list boxes separate?
And, WHY are you doing this?