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

[franc sutherland]

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.

 

[Mike Painter]

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.

The dirty property should give you what you want.
However making a change and then deleting teh record seems meaningles and
you usually inseret a new record. INserting a changed record may lead to
problems.

 

[franc sutherland]

The dirty property should give you what you want.
However making a change and then deleting teh record seems meaningles and
you usually inseret a new record. INserting a changed record may lead to
problems.

Hi Mike,
Thanks for responding.
The dirty property doesn't work. I think that is because the listbox
is not bound to the underlying form's data.
I probably didn't make myself clear before. I don't insert a changed
record. When the user clicks on an item in the list box, it either
removes that table entry or adds in a new one, depending on whether it
has become selected or de-selected.
Franc.