navigation buttons

[Chris Eisert]

Hey everyone,

The navigation bar tat is standard on every form is a
little too small for my taste, so I'm trying to make a
bigger version of the standard navigation by adding the
corresponding buttons to the form itself. However, unlike
the navbar, I'd like to disable the previous/next buttons
once the end of the current records is reached.
Question: what is the best way to determine the end of
current records. I'm thinking about doing a
recordset.Find/recordset.Position/recordset.Count, but I
was hoping that there might be a nicer way.

Thanks in advance

Chris

 

[Van T. Dinh]

In the Form_Current Event, use:

Me.cmdPrev.Enabled = (Me.CurrentRecord > 1)
Me.cmdNext.Enabled = (Me.CurrentRecord <
Me.RecordsetClone.RecordCount)

HTH
Van T. Dinh
MVP (Access)

 

[PC Datesheet]

You have to also put the same code in the OnClick event of the buttons --

 

[Van T. Dinh]

Steve

IMHO, I don't think so since when previous or next Record becomes the
Current Record, the Form_Current Event will occur.