As NeoPa has said, your post is not really clear. If by
I would like to generate a pop up box to ask if they want to save this change or add a new entry or cancel
you're saying that you want to change data in an existing record, then ask the user if they want to
Save the changed, existing record or
Save As a new record, as you would if modifying a word processing file, the answer is going to be that there is no native Access code or VB Script to do this. Access doesn't work like this, an existing record is an existing record, it can't be
Saved As another, new record.
If you want to create a new record, using much of the data from an existing record, you can copy the original record, then edit this copy as needed. The
Command Button Wizard will do this for you.
You can also utilize, with pretty standard code, the
Form_BeforeUpdate event to popup a
Messagebox, asking the user if they want to save changes to an existing record or save a newly created record.
Welcome to
Bytes!
Linq
;0)>