Subject Re: "with lock" SQL function
Author bwc3068
PS. I'm sure I don't need to supply this info but without the "with
lock" on the edit-SQL and with .PessemistictLocking = False, both
users can display the grid and put the same record into edit mode. Or
have one user in edit and the other re-fresh their display query with
no errors.

If both are in edit mode, the 2nd post and commit is what becomes the
current data.

Thanks again
Kelly