The issue with using the Recordset.edit method is that while the record is correctly updated in the table, the record does not update in the Form recordset (where as the db.Execute method updates in the Form recordset immediately...when it works), its the same for Docmd.runsql

And I want to avoid requery of the form recordset if possible as it could change the records available to the user.