Finding a value NOT selected in a listbox?

[BinaryGirl23]

Hello everyone,

I'm having a bit of a problem regarding Access 2003 which I really hope is an easy one to solve! I'm using a multiple-selection listbox control to look up values of one table and then it takes the selected values and puts them into a memobox (the values are delineated by a comma) that we can print on a report.

What I would like to have happen is that the user be presented with this same list of possible fields to select from. They choose the values that they want to include (which goes into a memo box called 'inclusions'), but then the remainder of the values (the values that were NOT selected) be put into a separate memo box called 'exclusions'.

Is this possible? I'm hoping that it's something easy but even if there is some random work-around solution I'm open to any possibilities! : )

Thanks for your help!

-Catherine

[nico5038]

Your problem reminds me of a sample database I once built for moving selected fields to another listbox, the same way Access uses to select fields in a wizard.

Just check:
http://www.geocities.com/nico5038/xS...p-Down2000.zip
Just check the form "frmMoveLeftRight" and see that the listbox is based on a table with a YesNo field ("LeftRight") to determine in which listbox the data needs to appear.
Having this implemented will allow you to build the Include Memo field from a query selecting the YesNo field to be True and for the Exclude Memo field with the value False.

Getting the idea?

Nic;o)

[BinaryGirl23]

Thanks Nico!

It took me a while to get this all to work with the code I was using but I couldn't have done it without you! You guys on here are really smart - I really had to wrap my brain around this for a while lol

-Catherine

[nico5038]

Well done !
I always admire people that can work with my cryptical first directions. I normally start that way so I don't spoil the fun of the discovery of the final solution.

Success with your application !

Nic;o)