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!