Knowledge can't be divided, only multiplied
It's the quality of the team that makes a Q&A site work
Saturday 29 November 2008, 4:39 PM
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)
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)
Previous
Private message disabled
