In the edit form, we can edit data but the local recordset is not updated, even if we press save, the form still shows the pre-edit data if we use the navigation controls on the form.

Is there an elegant way to sort this out, currently I am thinking of reloading the recordset after the SQL UPDATE routine, but I think there will be a better way to do this