[AccessD] Extended Combobox Questions

[jack drawbridge]

Arthur,

For multiselect use Listbox not ComboBox.
For your sql
SELECT whatever FROM yourtable
WHERE someField IN (PK1,Pk2,Pkn)

Good luck.

On Sat, Jul 3, 2021 at 11: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
>