how to determine if the rows selected in a simple multi-selectlistbox have been changed?

#1

Hi,
I want to find a way to determine if the rows selected in an unbound
simple multiselect listbox has been changed by the user.
There are ten options in the listbox.
Selecting rows changes the entries in a table using DELETE and INSERT
sql statements.
I want to be able to check if the user has made any changes and ask
them to confirm the changes before applying the DELETE and INSERT
statements.
Many thanks,
Franc.

#2

franc sutherland <franc.sutherland (AT) googlemail (DOT) com> wrote in
news:d3b3701d-6d1a-4e04-9fe5-1664d07a2012 (AT) u17g2000yqe (DOT) googlegroups.com:

Quote:

Hi,
I want to find a way to determine if the rows selected in an unbound
simple multiselect listbox has been changed by the user.
There are ten options in the listbox.
Selecting rows changes the entries in a table using DELETE and INSERT
sql statements.
I want to be able to check if the user has made any changes and ask
them to confirm the changes before applying the DELETE and INSERT
statements.
Many thanks,
Franc.

Use the Form_Current event to store the listbox.ItemsSelected status to

an array and then compare the array to the listbox in the code that
generates the delete and insert statements

--
Bob Q.
PA is y I've altered my address.

#3

On Feb 15, 10:13*pm, Bob Quintal <rquin... (AT) sPAmpatico (DOT) ca> wrote:

Quote:

franc sutherland <franc.sutherl... (AT) googlemail (DOT) com> wrote innews:d3b3701d-6d1a-4e04-9fe5-1664d07a2012 (AT) u17g2000yqe (DOT) googlegroups.com:

Hi,
I want to find a way to determine if the rows selected in an unbound
simple multiselect listbox has been changed by the user.
There are ten options in the listbox.
Selecting rows changes the entries in a table using DELETE and INSERT
sql statements.
I want to be able to check if the user has made any changes and ask
them to confirm the changes before applying the DELETE and INSERT
statements.
Many thanks,
Franc.

Use the Form_Current event to store the listbox.ItemsSelected status to
an array and then compare the array to the listbox in the code that
generates the delete and insert statements

--
Bob Q.
PA is y I've altered my address.

Hi Bob,
Perfect, works a treat.
Many thanks,
Franc.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

how to determine if the rows selected in a simple multi-selectlistbox have been changed?

comp.databases.ms-access comp.databases.ms-access

how to determine if the rows selected in a simple multi-selectlistbox have been changed? - 02-15-2011 , 09:09 AM

Re: how to determine if the rows selected in a simple multi-select listbox have been changed? - 02-15-2011 , 04:13 PM

Re: how to determine if the rows selected in a simple multi-selectlistbox have been changed? - 02-17-2011 , 02:57 AM