Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Hookom, Duane
  New Posts New Posts RSS Feed - Listbox with Multiselection used in Query
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Listbox with Multiselection used in Query

 Post Reply Post Reply
Author
Message
Duane Hookom View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 20 Feb 2008
Location: Eau Claire, WI
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote Duane Hookom Quote  Post ReplyReply Direct Link To This Post Topic: Listbox with Multiselection used in Query
    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
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.