navigation buttons sometimes require two clicks to move

[pgcn]

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

[Allen Browne]

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.

<pg**@westnet.com.auwrote in message
news:cb**********************************@p69g2000 hsa.googlegroups.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

[pgcn]

On Jan 15, 11:21*pm, "Allen Browne" <[e-mail]>
wrote:

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.

<[e-mail] in message

news:cb**********************************@p69g2000 hsa.googlegroups.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- Hide quoted text -

- Show quoted text -

of course!

Cheers Allen

[Alan]

On Jan 15, 4:59 pm, [e-mail] wrote:

On Jan 15, 11:21 pm, "Allen Browne" <[e-mail]>
wrote:

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.

<[e-mail] in message

news:cb**********************************@p69g2000 hsa.googlegroups.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- Hide quoted text -

- Show quoted text -

of course!

Cheers Allen

Hi Allen: I have the same problem with having to double click the
navigation bar twice to recalculate and move between records. I
removed all the events and still the same annoying behavior. If I add
a commandbutton to move between records it works fine. Any suggestions
are greatly appreciated. Alan

[Alan]

On Feb 2, 12:03 pm, Alan <[e-mail]:

On Jan 15, 4:59 pm, [e-mail] wrote:

On Jan 15, 11:21 pm, "Allen Browne" <[e-mail]>
wrote:

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.

<[e-mail] in message

>news:cb**********************************@p69g200 0hsa.googlegroups.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- Hide quoted text -

- Show quoted text -

of course!

Cheers Allen

Hi Allen: I have the same problem with having to double click the
navigation bar twice to recalculate and move between records. I
removed all the events and still the same annoying behavior. If I add
a commandbutton to move between records it works fine. Any suggestions
are greatly appreciated. Alan

After deleting one control at a time I found the culprit. A bound
control. Thanks anyway