I've created a database with RecordsetType Snapshot, so the user can't modify the data displayed on the text boxes. However, I'd like to create a button "Update" that could allow the user to update data if necessary. But to do so, I guess I would have to change the RecordsetType of my database to Dynaset, and once the update is done, make it back to Snapshot. How can I do this? Is there another way to solve this?