[AccessD] Extended Combobox Questions

[jack drawbridge]

Arthur,

Combo boxes allow a single choice. List boxes allow multiple selections.
Here is an example of multiselect listbox by Ken Sheridan
<https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_winother-mso_2016/microsoft-access-multi-select-combobox/7ef512d7-6060-42bf-ab3f-c3032d58d733>
from answers.microsoft.com

On Sat, Jul 3, 2021 at 4:06 PM Arthur Fuller <fuller.artful at gmail.com>
wrote:

> Jack,
> Thanks, but  I have a question: Why do you prefer a listbox rather than a
> combobox? What are the disadvantages to a combo rather than a list? I have
> no preference either wa. I used to have code that did precisely what I
> need, but even backup hard disks die. I think I got the original code from
> Ken Getz's book but now can't find either the code nor the book.
>
>
> On Sat, Jul 3, 2021 at 11:33 AM Ryan W <wrwehler at gmail.com> wrote:
>
> > I can’t help with point 1 but I use Allen Browne’s concatrelated function
> > often when I’m building a query with an IN() clause.
> >
> > http://allenbrowne.com/func-concat.html
> >
> > Sent from my iPhone
> >
> > > On Jul 3, 2021, at 10:24 AM, Arthur Fuller <fuller.artful at gmail.com>
> > wrote:
> > >
> > > 1,The combobox has two columns, the first being the PK of the row in
> the
> > > source row in the table, the second a text description. The user may
> > > select several items, or even all of them.  I refer to the selected
> > items?
> > > 2. I want to concatenate the PKs selected for use in the In() clause
> of a
> > > SQL statement. Given that they are numeric, is it enough just to wrap
> > them
> > > in STR() calls?
> > >
> > > --
> > > Arthur
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>