>>The whole thing is a mover class with 2 List boxes and an Add & Remove button.
>>If you´re interested I can send it to you.
>>
>>I hope this is clear enough and I´d be much obliged for further input!
>>
>>Best regards
>>
>Peter,
>
>Ok I see now, I build my movers with addlistitem and leave the rwosourcetype as None. In a nutshell,
>
> 1. I run the query
> 2. I scan the result
> 3. I do an addlistitem for each record in the result
>
>The I manage the lists by adding and removing items fromt he list. When the user is done I scan the selected list and add records to whatever tables I need to in code. The queries are not updatable and they only used to initially populate the lists. All of the list managment is code in form's methods. I form methods for SelectOne, SelectAll, UnselectOne, and UnselectAll which get called by the double click's in the lists and by the appropriate selection button's.
>
>Doin it this way make my life very easy as I am not concerned about the issue that is giving you a headache.
Jim,
In the meantime I´ve had a couple of useful tips, and have actually finished the class! As far as I´ve tested it seems to work and I´ll be uploading the whole thing here soon.
Maybe you´ll take a loók at it?
Regards
Peter
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)