Hi there - I'm working with a legacy mdb that has a tab on the form. On one of of the tabs, I'm using a SQL statement that will update a field on another one of the tabs (If this particular record is updated, the field on the other tab will also get updated). When I execute the statement, I get a message stating "Could not update, currently locked". Now obviously since I'm the only user, I'm assuming the reason I'm getting this message is because the field I'm trying to update is currently open in another tab(If I close the form and run the query it updates fine). Is there a property I can set to prevent this? I've tried setting the forms Record Locks property to "No Locks", had no effect. Any help would be appreciated, thanks.