Hello forum
I am attempting to allow multiple user-selected items for an SQL-driven Table-Update.
The SQL statement will update a given table in its date column (to the current date) and will tare the quantity column to 'zero' based upon whichever items are selected (which are keys within the given table). This all works well when only one item is selected, but goes awry with multiple selections.
I am trying to save the user time by allowing multiple selections...
Any ideas.
Pls request additional info, if needed...
Thanx,
H8-2B-L8

Build a WHERE clause for your sql with the appropriate field of each row selected.

You'll have WHERE "[FIRSTFIELD] =" & LISTBOX.ROW1.COLUMN(?) & " AND [SECONDFIELD] =" & LISTBOX.ROW1.COLUMN(?)

where LISTBOX.ROW1.COLUMN(?) is an array cell containing the correct column of the 1st selected row and

LISTBOX.ROW1.COLUMN(?) is an array cell containing the correct colu7mn of the 2nd selected row, etc.

LISTBOX.ROW1.COLUMN(?) is an array cell containing the correct colu7mn of the 2nd selected row, etc.

should be

LISTBOX.ROW2.COLUMN(?) is an array cell containing the correct column of the 2nd selected row, etc.