Saving Dual Entries:

[JWT]

Hello,

I have one Form set to one Table and need to know how to change to edit information in my Table.
I have set a Macro to check for an existing number and reopen or start a new entry. My Macro is on “after update” and is in text box that starts:

Go To Control Number],
Find Record = [Number],
Beep

This work OK, My next Macro is just a label and “On Click” starts:

Save Form
Beep
Go to Record [Number]

Now here is where I need help, the new entries are OK but when it is an update/edit is saved the old information is updated and a new line is saved with just the old number in the next line in my Table. What is needed?

Thanks, JWT