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


Please consider donating $1 per sample downloaded, (find out why here)

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


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down