navigation buttons

  • Thread starter Thread starter Chris Eisert
  • Start date Start date
C

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
 
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)
 
Steve

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