Ok, that's a different issue. You want to prevent the automatic save. I
realize that's what you said in your subject but I was going by the body of
your question. My apologies. You would use the form's Before Update event to
trigger a review process/message box or whatever else you want to do before
they leave the record.
Glenn
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Lee
Sent: June-01-12 2:51 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Preventing moving to next record with a dirty
form
Right, because it saves by default I want a prompt to force them to review
anything they've changed before they move on. A lot of times someone will
make a change, get distracted, then 25 minutes later forget they changed
something (maybe they deleted a field to type something else in) and move
on. I want to force a double check before going to the next record.
--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Glenn Lloyd"
<argeedblu@...> wrote:
>
> Lee,
>
>
>
> I am afraid I don't understand the question then. How can the user
navigate
> away without saving the data? By default, when the user navigates away
from
> a record, the record is saved before the next record is activated or the
> form is closed.
>
>
>
> Glenn
>
>
>
> <mailto:glenn@...> Description: signature block_OTM
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Lee
> Sent: June-01-12 1:56 PM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] Re: Preventing moving to next record with a dirty
> form
>
>
>
>
>
> Right, I'm trying to prevent them from navigating away without saving. I
> just don't know where to put the dirty check to accomplish that.
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "Glenn Lloyd"
> <argeedblu@> wrote:
> >
> > Lee,
> >
> >
> >
> > Unless you have something in place that would prevent saving the data,
it
> is
> > saved by default as soon as the user navigates away from the record.
> >
> >
> >
> > Glenn
> >
> >
> >
> >
> >
> >
> >
> > From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Lee
> > Sent: June-01-12 1:27 PM
> > To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: [MS_AccessPros] Preventing moving to next record with a dirty
> form
> >
> >
> >
> >
> >
> > Hi,
> > I have a bound form that shows 1 record at a time. I use the default
> access
> > (03) navigation buttons at the bottom of the form allow the user to
switch
> > between records. I'm trying to make it so if a user makes changes to 1
> > record and then tries to move to another record without saving, they
will
> be
> > prompted to save first, but I can't figure out which event to put
"dirty"
> > check in.
> >
> > Thanks
> > -Lee
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar