List box error 1

[Bristowj]

I have two list boxes set up on a form which allow you to switch users from one box to the other and add and remove names to the listbox in order to emulate a profiles screen.

The first time I change the first row in the list box I have no problem but if I try to further change the data or move to another record in the list box I get a record lock error msgbox. I OK the error and can make the change OK, if I modify the first record further I get the same problem over and over. This only happens with the very first row in the list box, not any rows there after.


Error Desc:
The data has been changed:
Another user edited this record and saved the changes before you attempted to save your changes.
Re-Edit the record


I am the only user connected to this database
Can anyone help???????
%-(

 

[CPUburn]

hi,

this "You and another user"-thing happened to me a while ago, searched on it for a couple of hours and it prove to be an update of a recordset in VBA-code that conflicted with the actions that were manually taken i.e. by user input in the form.
If, keeping this in mind, you're not able to solve it, plz show us a piece of the code u use.

greetings,

cpuburn

 

[Bristowj]

cpuburn,
Thanks for the tip!!! I actualy managed to fix it by putting an "order by" clause into the select statement on the list box. Not sure how this is working, maybe a bug???

Cheers
Jonas