How to lock a record from table I want not lock a record from a form

[Taken]

my probem is when I test with two form, with loop an doevents for each user, on click on button, the edit of the first user (first click on button) will not be saved. the edit of the second user will be saved

[Rabbit]

That's odd. Try 2,1,2

[Taken]

That's it Robbit thank U so mutch,

[Rabbit]

No problem, but you should be aware that the lock lasts only as long as the object. It won't keep the lock if the user wants to come back to the record later to finish up.

[Taken]

Another Problem
2, 1, 2 lock all the table, my aime was to lock one record
2, 2, 3 lock one record but if two users clic for the same record
the edit of the first user will be ignorent

[Rabbit]

At this point, I don't know which combination is going to work, you could try all the possible combinations until you find the one that does.

[Taken]

Ok thank you Rabbit, when I find the solution I'll post it