Could not update record locked by user

[Guest]

Hello,

I have a problem that only seems to happen with a few records on my
database. I have a form which displays most of the data on a record, but it
is locked to avoid any accidental deletions etc.
I have a command button which opens another popup form which displays the
data but it is unlocked, for example the address. When they change the
details I have programed in VBA to add a comment (string) into a memo field
which is displayed on the main form. This works 99% of the time but with some
records it comes up with the error "Could not update, currently locked by
user Admin on this machine"

I use the code
Me.comments = Me.comments & Date & " details updated"

I have tried runcommand accmdsaverecord before and after but it still comes
up with that error.

Any help would be brilliant as this is starting to become a problem.

Many thanks

James

 

[Guest]

Hello, Please can someone help me with this as it is starting to happen more
and more and it is taking up time to manualy do everything.

Many thanks

James