Cant Update due to Locks but same SQL update works

[wmagargle]

Hi All, I created a form for users to use to update a date on an order. Its a simple update, 1 field. Access complains about locks, but I can run the exact same update from SQL. Any ideas?



UPDATE dbo_VI_PS_DOC_LIN_SHIP_DAT SET dbo_VI_PS_DOC_LIN_SHIP_DAT.TA_REQ_SHIP_DAT = [Forms]![frmMain]![NeWdAtE]
WHERE (((dbo_VI_PS_DOC_LIN_SHIP_DAT.TKT_NO)=[Forms]![frmMain]![tktNo]) AND ((dbo_VI_PS_DOC_LIN_SHIP_DAT.LIN_TYP)<>"f"));

[June7]

Is the form RecordSource a query that joins tables? Show the sql statement.