checking for the first or last record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a custom "previous" and "next" buttons.

How can I disable them when I reach the first or last record?

The form does now allow for additions.

Thank you!
 
If Me.CurrentRecord = Me.Recordset.RecordCount Then
'It is the last record
End If

If Me.If Me.CurrentRecord = 1 Then
'It is the first record
End

This may not work pre A2K
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
Code wont trigger 5
How do i enable and disable navigation buttons in Access 2003 2
Need help getting RecordsetClone to work 6
Access Main form/Subform Navigation 0
go to next record issues 1
Not finding EOF - 'no current Record' error 9
ListBox and Navigation on Unbound forms 6

Back
Top