Print Page | Close Window

Listbox with Multiselection used in Query

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Hookom, Duane
Forum Description: Duane Hookom's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=17
Printed Date: 11 Dec 2017 at 11:25pm


Topic: Listbox with Multiselection used in Query
Posted By: Duane Hookom
Subject: Listbox with Multiselection used in Query
Date 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: http://www.rogersaccesslibrary.com/forum/uploads/4/MultiSelectListBoxQuery.zip - uploads/4/MultiSelectListBoxQuery.zip

-------------
--
Duane Hookom
Microsoft Access MVP
Eau Claire, WI



Print Page | Close Window