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

  • Thread starter Thread starter franc sutherland
  • Start date Start date
F

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.
 
franc said:
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.
Click to expand...

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.
 
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.
Click to expand...

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.
 
Back
Top