>I am using a form to copy an existing record to a new record and changing a value by
>increasing the value by 1 in one field.
>
>I am using insert and replace to accomplish this, however, when I run the code the value in
>the field is always changed to 2 instead of 1.
>
>I am copying the field to a variable and then using replace with variable + 1 to change the value.
>
>What am I doing wrong???
>
>Thanks and have a great day!

is the value (existing record) already equal to 1?
if not, is this call being executed twice?