Help me to update a record via coding or through macro

[digitalbalu]

Hi,


Here is my customer entry form. Add new button & Delete button works correctly. But by default all the records saved automatically. I want new record or edit record should be saved after I press the Save/update button otherwise it must be cancelled. How and where to write the code? Please help me...

Thanks in advance..

[alansidman]

One way would be to use an unbound form to add your data. See the link for how to do that.

http://www.datapigtechnologies.com/f...rdsnocode.html

[digitalbalu]

Thanks alansidman. But my form is bounded one. I just want save & update must be executed after the save button pressed.'

[June7]

Never seen anything like that. I suppose you could have an unbound textbox (could be hidden) that would be set to "Saved" when the Save button is clicked. Then when the Close button is clicked, check value of textbox and if it doesn't say "Saved" cancel the record. Have the textbox DefaultValue property set to "Not Saved" so that new record will not have the "Saved" value.

However, I've not had much luck with 'canceling' a record by using the Undo method.