Using a command button for previous and next record. Get "You can't go to the specified record."

[G3K0]

So I think there is a simple answer here, but I am not sure why it happens. In a form, I have a command button for moving through records. Attached to this button is basic VBA code.

Private Sub btnPreviousRecord_Click()


DoCmd.GoToRecord , , acPrevious
End Sub

Easy Enough. When I click the previous button once, I go to the previous record, when I click it again, I get the error "You can't go to the specified record." I click End on the popup, and I click the previous record button again and go to the previous record.

I can sift through all of my records, but every other click on either the previous or next button, I get a popup saying I can't go to the next record, even though it exists. The only true time that a record does not exist is when I press previous on the very first record, or next on the very last record.

Suggestions?

[ranman256]

if you are at the 1st record you cant go to previous.
theres no need for these buttons, access provides them at the form footer.
NAVIGATION BUTTONS = TRUE

[G3K0]

Ranman256,

Thanks for the info, yes I am aware I cannot go to the previous when I am at the very first and the next when I am at the very last. Adding these buttons is TECHNICALLY not necessary, I am also aware of the navigation buttons at the bottom, but for someone new coming across the form, it is more intuitive to have the obvious arrow buttons in my opinion. I do have code that grays out the previous arrow on the first record and grays out the next arrow on the last record.

[aytee111]

There seems to be a lot out there on this subject. One suggested that the form loses focus when moving to another record and said to add the line Me.Setfocus. There are also mentions regarding the events that are fired, such as the BeforeUpdate and AfterUpdate among others.

[Bulzie]

Maybe add error handling code in that button and trap that error, if it says "Cannot go to Previous Record" or whatever, just point it back to that button me.button.setfocus instead of displaying a pop up.

[davegri]

You might be doing something in the Form_Current event that's causing this. Try commenting out the event and see what happens.