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 sutherland wrote:
> 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.

On Feb 14, 9:50*pm, "Mike Painter" <md.pain...@sbcglobal.net> wrote:
> franc sutherland wrote:
> > 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.

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.