CreateMultiSelectQuery.mdb (intermediate) |
Post Reply |
Author | |
Roger Carlson
Microsoft MVP Joined: 20 Feb 2008 Status: Offline Points: 261 |
Post Options
Thanks(0)
Posted: 01 Aug 2008 at 6:40am |
Please consider donating $1 per sample downloaded, find out why here.
CreateMultiSelectQuery.mdb This database illustrates how to create a query programmatically based on the selected values of a multi-select list box.
It creates a query which uses the IN clause to compare the field against a list. The routine loops through the list and builds the IN string from the values selected, creates the WHERE condition based on the IN string, and if "ALL" was not selected as one of the choices, appends the WHERE condition to the SELECT statement. |
|
|
|
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 |