469,647 Members | 1,770 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,647 developers. It's quick & easy.

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
Jan 14 '08 #1
4 1574
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
Jan 15 '08 #2
On Jan 15, 11:21*pm, "Allen Browne" <AllenBro...@SeeSig.Invalid>
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.

<p...@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- Hide quoted text -

- Show quoted text -
of course!

Cheers Allen
Jan 15 '08 #3
On Jan 15, 4:59 pm, p...@westnet.com.au wrote:
On Jan 15, 11:21 pm, "Allen Browne" <AllenBro...@SeeSig.Invalid>
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.
<p...@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- 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
Feb 2 '08 #4
On Feb 2, 12:03 pm, Alan <a...@comcast.netwrote:
On Jan 15, 4:59 pm, p...@westnet.com.au wrote:
On Jan 15, 11:21 pm, "Allen Browne" <AllenBro...@SeeSig.Invalid>
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.
<p...@westnet.com.auwrote 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
Feb 2 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Mike MacSween | last post: by
3 posts views Thread by fred14214 | last post: by
6 posts views Thread by John | last post: by
1 post views Thread by D Lutheran | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.