Thursday, March 12, 2009

Ab-normalization at Experts Exchange - part 4

The question today:
How to choose multiple records when using a drop-down-list on an Access form?

It's impossible to use a combo box for a multiple selection. So the proposed solution is to use a list box with the Multi Select property set to Simple or Extended.
To create the necessary filtering with the selected items the #1 Access "expert" proposes to use some VBA code to loop through the Items Selected collection.
Impressive, but unnecessary.

There's a code less solution by using a sub form with a Yes/No field for the selection and now you can JOIN the reporting query with the sub form table and filter for the Yes/No field to be True.

It's an amateurs approach to use code to solve problems, but did I expect otherwise from the Experts Exchange #1 expert ?

Nic;o)
Still proud to be suspended from this "quality site" where wannabee experts rule and "quality" is just another word from the dictionary.
(The question can be found at: http://www.experts-exchange.com/Q_23822041.html)

No comments:

Post a Comment