navigation buttons sometimes require two clicks to move

Hi

Using A2003

My db has main form [frmStakeholders] with stakeholderID & other main
details.
When there are a number of detail subform records it often requires
two clicks of the next/previous nav buttons to move to the next/
previous record. (regardless of whether or not the subfrm is dirty).

The subform [frmSHDetails] has a text box "DateChanged" which updates
on the AfterUpdate of [frmSHDetails]: (this control blinks when a nav
button is clicked).

Private Sub Form_AfterUpdate()
If Format(Me.DateChanged, "dd/mm/yyyy") <> Format(Now(), "dd/Mm/
yyyy") Then
Call Changed
End If
End Sub

Private Sub Changed()
Me.fUserID = [Forms]![frmLogIn]![fUserID]
Me.DateChanged = Now()
End Sub

Any help to fix this annoying behaviour is sincerely appreciated.

Peta

Re: navigation buttons sometimes require two clicks to move

Move the code into Form_BeforeUpdate.

If you use Form_AfterUpdate, you dirty the form again as soon as the record
is saved. So it has to save again, which again dirties it straight away. So
it has to save again, which ...

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

wrote in message
news:cb1df428-4225-48f2-886d-05639c36b10e@p69g2000hsa.google groups.com...
> Hi
>
> Using A2003
>
> My db has main form [frmStakeholders] with stakeholderID & other main
> details.
> When there are a number of detail subform records it often requires
> two clicks of the next/previous nav buttons to move to the next/
> previous record. (regardless of whether or not the subfrm is dirty).
>
> The subform [frmSHDetails] has a text box "DateChanged" which updates
> on the AfterUpdate of [frmSHDetails]: (this control blinks when a nav
> button is clicked).
>
> Private Sub Form_AfterUpdate()
> If Format(Me.DateChanged, "dd/mm/yyyy") <> Format(Now(), "dd/Mm/
> yyyy") Then
> Call Changed
> End If
> End Sub
>
> Private Sub Changed()
> Me.fUserID = [Forms]![frmLogIn]![fUserID]
> Me.DateChanged = Now()
> End Sub
>
> Any help to fix this annoying behaviour is sincerely appreciated.
>
> Peta

Re: navigation buttons sometimes require two clicks to move

On Jan 15, 11:21=A0pm, "Allen Browne"
wrote:
> Move the code into Form_BeforeUpdate.
>
> If you use Form_AfterUpdate, you dirty the form again as soon as the recor=
d
> is saved. So it has to save again, which again dirties it straight away. S=
o
> it has to save again, which ...
>
> --
> Allen Browne - Microsoft MVP. =A0Perth, Western Australia
> Tips for Access users -http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> wrote in message
>
> news:cb1df428-4225-48f2-886d-05639c36b10e@p69g2000hsa.google groups.com...
>
>
>
> > Hi
>
> > Using A2003
>
> > My db has main form [frmStakeholders] with stakeholderID & other main
> > details.
> > When there are a number of detail subform records it often requires
> > two clicks of the next/previous nav buttons to move to the next/
> > previous record. (regardless of whether or not the subfrm is dirty).
>
> > The subform [frmSHDetails] has a text box "DateChanged" which updates
> > on the AfterUpdate of [frmSHDetails]: (this control blinks when a nav
> > button is clicked).
>
> > Private Sub Form_AfterUpdate()
> > =A0 =A0If Format(Me.DateChanged, "dd/mm/yyyy") <> Format(Now(), "dd/Mm/
> > yyyy") Then
> > =A0 =A0 =A0 =A0Call Changed
> > =A0 =A0End If
> > End Sub
>
> > Private Sub Changed()
> > =A0 =A0Me.fUserID =3D [Forms]![frmLogIn]![fUserID]
> > =A0 =A0Me.DateChanged =3D Now()
> > End Sub
>
> > Any help to fix this annoying behaviour is sincerely appreciated.
>
> > Peta- Hide quoted text -
>
> - Show quoted text -

of course!

Cheers Allen