CreateMultiSelectQuery.mdb (intermediate)

Please consider donating $1 per sample downloaded, find out why here
Download
CreateMultiSelectQuery.zip
Access 97 (24 KB)

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.

 

Feedback

 

Need Winzip?

Return to Main Page