Actually, its not as simple as that. I find that switching focus across the
two boxes doesnt always produce the error. It mostly happen on the click
event of one box just after the focus is brought to that box and
double-clicking the top item in the other box.
I am really at a loss to what is really taking place. It could be either the
enter , exit , gotfocus, lostfocus, or click event of one of the boxes that
is raising the error.
Hope that makes it clearer.
Quote:
> I have a form with two listboxes. DoubleClicking an item in either listbox
> edits the data in the field, of the underlying table, to which both
> listboxes are bound, and the item moves over to the other listbox. The
> second (and sometimes the first) double-click attempt, after changing the
> focus to either box, produces this error:
> "The Data Has Been Changes - Another user edited the record and saved the
> changes before you attempted to save your changes. Re-edit the record."
> After dismissing this message, the only way you can - clicking OK, you can
> perform any number of double-clicks without error, until the focus is
> changed to the other listbox. At this point the same thing happens all
over
> again.
> This is a stand alone db. and I dont have any other processes running. Why
> am I getting this error?
> Thanks
Access Error