Record lock violation cancelling an update query

[cys813]

I have a simple update query that I need to run in a form but Im having some trouble. at first, my update query wasn't working so I took off docmd.setwarnings = false to see what kind of error msg i get.

I am currently getting a msg "Microsoft Office can't update all the records in the update query... 1 record due to lock violations... "

what does this mean?

my query sql is

UPDATE tbl_CapitalPrs SET tbl_CapitalPrs.ApprovalCode = [forms]![frm_ApprovalCode]![txtcode]
WHERE (((tbl_CapitalPrs.PrNum)=[forms]![frm_ApprovalCode]![cboPR]));

a simple query that updates the approval code as what users input on the form. But the query will not update the table.. any solutions?

 

[Golom]

Look at Lock Violations on Allen Browne's site.

 

[cys813]

i have already tried setting the default record lock settings to "NO LOCKS". any other reasons why this is happening?

 

[cys813]

k i figured it out. it was because I accidentally bounded the combo box. unbound and it's working fine. thx anyway