Copying items from one list to another in the same(or different) f

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sara - 13 Jun 2007 16:17 GMT

Hi,

I am working in a form that has 2 list boxes, I need to be able to select
items from list 1 and drag and copy the selected items into list 2.
I found a module in Microsoft page that does something very similar to what
I want with the exceptionm that this code removes the selected items from
list 1 and pastes them to list 2.

I will provide the link for the code I am using:

http://support.microsoft.com/kb/287642

I would really appreciate your help.

Reply to this Message

Sara - 13 Jun 2007 16:22 GMT

BTW, I am using example 2 of the link

http://support.microsoft.com/kb/287642

> Hi,
>
[quoted text clipped - 9 lines]
>
> I would really appreciate your help.

Reply to this Message

Douglas J. Steele - 13 Jun 2007 18:05 GMT

The reason it no longer shows up is because you updated Selected from False
to True. The RowSource for List1 only returns those records where
Selected=False. Change that so that it returns all records in Customers,
regardless of the value of Selected.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> BTW, I am using example 2 of the link
>
[quoted text clipped - 14 lines]
>>
>> I would really appreciate your help.

Reply to this Message

Sara - 13 Jun 2007 18:31 GMT

You are right, thanks

> The reason it no longer shows up is because you updated Selected from False
> to True. The RowSource for List1 only returns those records where
[quoted text clipped - 19 lines]
> >>
> >> I would really appreciate your help.

Reply to this Message