Re: And/Or Option Group for Multiselect List Box
- From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
- Date: Sat, 19 May 2007 06:55:36 -0400
If I'm understanding your question correctly, this has nothing to do with
And vs Or.
When dealing with a multiselect list box, you have no choice but to
dynamically regenerate the SQL, using code such as is presented in
http://www.mvps.org/access/forms/frm0007.htm at "The Access Web". If the
user indicates that they want to select all values in the list box, simply
ignore that field in your Where clause.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"emily" <emily@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5797126F-4861-4E99-9389-523D289F5303@xxxxxxxxxxxxxxxx
Hello,
I'm not sure if this is possible, but I would like to create a multiselect
list box that has option group controls of 'And' and 'Or' that will allow
the
user to search either all of the selections from the list box or any one
of
the selections.
My table is tblSkills and the field name is Skill. I want the list box to
populate a list of skills and allow the user to find an employee with
either
all of the skills selected or any one of the skills selected.
Thanks so much for your time and effort!
.
- Prev by Date: odbc advise requested
- Next by Date: Re: Roundup value with Int function
- Previous by thread: odbc advise requested
- Next by thread: Re: And/Or Option Group for Multiselect List Box
- Index(es):
Relevant Pages
|
