stopping a form from saving records

[LAazsx]

Hi, i want to make a "save" button for my form. Is there a way to prevent the form from writing records instantly? and how do i code the button to "save" the record?

[ajetrumpet]

a form, technically, is just a table that looks different. that's why the records do that.

if you use:

me.undo

you can reverse any updates made to a form record, and even cancel the entry of a new record, by checking the:

me.newrecord

property.

on a button like that, more than likely this would be fine:

runcommand accmdsaverecord

the:

docmd.save

doesn't do anything different than the runcommand for the record does. to my knowledge, that's only useful in design view, which is impossible of course.

[LAazsx]

if you use:

me.undo

you can reverse any updates made to a form record, and even cancel the entry of a new record, by checking the:

me.newrecord

property.

Sorry for the stupid question but where do i enter me.undo? and is me.newrecord the same as allow additions?

[ajetrumpet]

me.newrecord

is a property of the form. the return is a boolean. true or false. the return tells you if the current record is a new entry or not.

allowadditions

is the same thing. it's a property, nothing else. the setting of it (true or false) allows or not, the addition of new records through the interface. for instance, if you put a button on a form and put some new record code behind it, chances are access will error because it violates the "allowadditions" property that is set to "false". does that make sense?


all of these things are just tools at your disposal, as the programmer, that you can use to control user activity.

me.undo

like I said before, undoes any changes made to the CURRENT record only. it applies to one record at a time, and no more. you can call it a million times if you want. you can also put it in code at any time you want. it doesn't matter. but, to my knowledge, it will only do anything for you if changes have been made to the record.

so if your button takes the user to a new record, but they've changed the one they're on already, you can throw a message box to them and save the changes or not based on what they tell you. you would do so like this:

on button_click

if me.dirty then
   if msgbox("Hey!  you changed this rec's data.  should I save it for you?", vbyesno) = vbno then
      me.undo
         'GOTO new rec here
   else
         'JUST go to new rec
end if

hopefully that is clearer for you, and you can run with it! also please know, that the code I write on this forum I usually write by hand, as examples, so copying it and pasting it verbatim into a vb editor will surely not work for you the first time, unless I get lucky. (I'm no expert, just an experienced guy).

[LAazsx]

i think i got it. thanks