Prohibit record navigation

Hi

I need to block user from moving away from a record using any of
First/Last/Prev/Next/New Record or any other way IF the record has not been
saved, and displaying a message to the effect "Please finish editing". If
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11372-prohibit-record-navigation.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11372
however the user has explicitly saved the record using save from the access
menu then allow to move from record. How do I achieve this via code?

Thanks

Regards



*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

On Wed, 14 Jun 2006 00:39:21 +0100, "John"
wrote:

>Hi
>
>I need to block user from moving away from a record using any of
>First/Last/Prev/Next/New Record or any other way IF the record has not been
>saved, and displaying a message to the effect "Please finish editing". If
>however the user has explicitly saved the record using save from the access
>menu then allow to move from record. How do I achieve this via code?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11372
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11372

Set Cancel to True in the Form's BeforeUpdate event until you're
satisfied.

John W. Vinson[MVP]

Is there a way to distinguish between a) before update event due to explicit
save action from access menu and b) before update by other reasons such as
moving away from the record?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11372

Thanks

Regards
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11372

"John Vinson" wrote in message
news:crpu82lel42hqgv2sm8b83f3cluanck151@4ax.com...
> On Wed, 14 Jun 2006 00:39:21 +0100, "John"
> wrote:
>
>>Hi
>>
>>I need to block user from moving away from a record using any of
>>First/Last/Prev/Next/New Record or any other way IF the record has not
>>been
>>saved, and displaying a message to the effect "Please finish editing". If
>>however the user has explicitly saved the record using save from the
>>access
>>menu then allow to move from record. How do I achieve this via code?
>
> Set Cancel to True in the Form's BeforeUpdate event until you're
> satisfied.
>
> John W. Vinson[MVP]

On Wed, 14 Jun 2006 0337 +0100, "John"
wrote:

>Is there a way to distinguish between a) before update event due to explicit
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11372
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11372
>save action from access menu and b) before update by other reasons such as
>moving away from the record?

Not that I know of. The BeforeUpdate event fires upon any action which
causes the record to be saved to disk - navigating off the record,
closing the form, Records... Save, whatever. Why?

John W. Vinson[MVP]