Hi,
I have a form for data entry and noticed that when i enter data and
close the form, there is no warning and it writes directly to the
table(s).

Is this the default action?
Is there a way to fire a warning saying "do you want to save the info or
press cancel to close and not save etc"....

Thanks



*** Sent via Developersdex http://www.developersdex.com ***

On Fri, 20 Jan 2006 03:24:14 GMT, jim Bob <fromnz@gmail.com> wrote:

Yes. The same happens when you click a navigation button to go to a
different record. It's the way Access works. It won't take most people
more than a few days to get used to it, so for most applications it
doesn't pay off to fight it.

If yours is in that 0.01% class, you might want to put up a message
like this:
Private Sub Form_BeforeUpdate(Cancel As Integer)
If MsgBox("Wanna Save?", vbQuestion Or vbYesNo) = vbNo Then
Me.Undo
End If
End Sub

Again, you're going against the grain of Access. Only do this if you
REALLY have to.

-Tom.

[color=blue]
>Hi,
>I have a form for data entry and noticed that when i enter data and
>close the form, there is no warning and it writes directly to the
>table(s).
>
>Is this the default action?
>Is there a way to fire a warning saying "do you want to save the info or
>press cancel to close and not save etc"....
>
>Thanks
>
>
>
>*** Sent via Developersdex http://www.developersdex.com ***[/color]

Thanks for your comments.
Yeah, I know what you mean. I'm doing the db for highly un-tech people
and they posed this question. I'll "try" to convince them that this is
the way it is.
Cheers.



*** Sent via Developersdex http://www.developersdex.com ***