Saving Issue

[Ptrif]

I have a form that is used to monitor or grade employee customer service phone calls. The problem i am running into is when someone chooses say someones name on the form but then doesnt finish the form and closes it out it still writes the data to the table, is there anyway to avoid it from saving the data until the save button is pressed?

Any help or suggestions welcome!

Thank you!
Paul

 

[Crowley16]

try using form.undo in the onExit event of the form...

remember to put a form.update in your button so that it DOES save the record...

 

[Ptrif]

Is that all i put in the code is form.undo? I tried that and i still get the same result

 

[TheAceMan1]

How are ya Ptrif . . . .

Use the [blue]BeforeUpdate Event[/blue] of the form, its triggered each time a record is saved. You can validate the controls and use the [blue]Cancel[/blue] arguement with [blue]Undo[/blue] to roll back. Something like:

[blue]   If IsNull(Me!Text1) Or IsNull(Me!Text2) Then
      Cancel = True
      Me.Undo
   End If[/blue]

See Ya! . . . . . .