data entry forms writing directly to the tables?

[jim Bob]

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 ***

[Tom van Stiphout]

On Fri, 20 Jan 2006 03:24:14 GMT, jim Bob <fr****@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.

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 ***

[jim Bob]

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 ***