updating a form with new values

[weekend00]

Oops. I did not notice Tbl & Tbe.

It look's fine if [PresetOption] is a number field.

just set a break point to check what is in Me.frmPresetOption before the insert statement.

And I am not sure if you get the new value or old value in Me.frmPresetOption within beforeupdate event. change event maybe more suitable.

Private Sub frmPresetOption_beforeUpdate(Cancel As Integer)

[markjkubicki]

OK... i'll give it try later today and keep you posted
(thanks for all your attention, you're being a real trooper !!!)