Listbox with Multiselection used in Query |
Post Reply |
Author | |
Duane Hookom
Microsoft MVP Joined: 20 Feb 2008 Location: Eau Claire, WI Status: Offline Points: 12 |
Post Options
Thanks(0)
Posted: 23 Jun 2008 at 11:05pm |
This sample demonstrates how a multiselect listbox can be used as the criteria in a query. A generic function is used to return a True or False depending on if a field value is selected in a listbox on a form. There are two list boxes in the demo: one is bound to a numeric field and the other a text field. While this solution works great for smaller tables, it may not be the best olution for tables with 1000s of records. Download Access: 2000: uploads/4/MultiSelectListBoxQuery.zip |
|
--
Duane Hookom Microsoft Access MVP Eau Claire, WI |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |