I agree with JHausmann, but I also agree that it's much easier (but sloppier) with the data control.....

Before editing:
Data1.Recordset.Edit 'FOR DAO ONLY

here the user can change the contents of the bound textbox
text1.text = "My New Value"

When done editing
Data1.Recordset.Update 'commit changes
- or -
Data1.Recordset.CancelUpdate 'cancel changes

==================
This UBB code isn't too bad....

Tom