By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,916 Members | 1,286 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,916 IT Pros & Developers. It's quick & easy.

Finding a value NOT selected in a listbox?

P: 13
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
Oct 11 '07 #1
Share this Question
Share on Google+
3 Replies


nico5038
Expert 2.5K+
P: 3,072
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)
Oct 11 '07 #2

P: 13
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
Oct 12 '07 #3

nico5038
Expert 2.5K+
P: 3,072
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)
Oct 12 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.