Pop up to save data on a change to the data in a text & date box.

[smpolson]

I have a date and a text box on an Access form. If the data changes 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. Is there a VB script that will do this? Thank you!

[NeoPa]

I expect so, but you're really going to have to put a little more effort into your question before I can understand you clearly enough to help.

[missinglinq]

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_BeforeUpda te 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)>