Another User... (Message Box)

[DS]

I Have a Main Form with a ListBox and a Subform on it.
Whenever I select another item from the Listbox to change something on a
record I get a Message Box that says...

another user has edited and saved this record before you could save your
changes. Edit Record.

How can I stop this box from poping up so that I can change the record?
Thanks
DS

 

[Wolfgang Kais]

Hello DS (DataSet?)

I Have a Main Form with a ListBox and a Subform on it.
Whenever I select another item from the Listbox to change something
on a record I get a Message Box that says...

another user has edited and saved this record before you could save
your changes. Edit Record.

How can I stop this box from poping up so that I can change the record?

Have you probably bound the listbox to a field of the recordsource of the
main form.
If so, why has the main form a recordsource?
As I understand it, you only have the listbox (and a subform control)
on the main form, and you use the listbox to determine the record
shown in the subform. So, the selected value doesn't have to be
stored in any table.
If I'm right, clear the recordsource property of the main form and also
clear the controlsource property of the listbox.

 

[DS]

Hello DS (DataSet?)




Have you probably bound the listbox to a field of the recordsource of the
main form.
If so, why has the main form a recordsource?
As I understand it, you only have the listbox (and a subform control)
on the main form, and you use the listbox to determine the record
shown in the subform. So, the selected value doesn't have to be
stored in any table.
If I'm right, clear the recordsource property of the main form and also
clear the controlsource property of the listbox.

Thanks, WolfGang. I removed the recordsource from the Main Form. That
worked.
DS