Last Record Button Failure

[Ted C]

I've been using one of the standard Access buttons, the Last Record button, on a form in a training database. It allows the user to navigate through class sessions to see who attended, which is shown in a sub-form.



The problem is that it's no longer navigating to the last record. There are currently 770 records in the table it references (tblClassSession), but the Last Record button navigates to record 745.

Has anyone seen this behavior before?

On a related note, clicking the Next Record button will not get to record 746, it acts as if there are no records after 745.

[June7]

That may be a 'standard' button control but the code is custom. Show the code behind the button.

Show the main form RecordSource sql.

Are the main form Filter, FilterOn, SortBy properties set?

[Ted C]

Here's the button code for Last Record.

Private Sub LastRecord_button_Click()
On Error GoTo Err_LastRecord_button_Click

    DoCmd.GoToRecord , , acLast
Exit_LastRecord_button_Click:
    Exit Sub
Err_LastRecord_button_Click:
    MsgBox Err.Description
    Resume Exit_LastRecord_button_Click
    
End Sub

[Ted C]

SQL from the top level of the form.

SELECT tblClassSession.*, tblClass.ClassName, tblLocation.LocationName
FROM tblClass RIGHT JOIN (tblLocation RIGHT JOIN tblClassSession ON tblLocation.LocationID = tblClassSession.LocationID) ON tblClass.ClassID = tblClassSession.ClassID;

[Ted C]

Design view of the form query.

[Ted C]

Form properties.

[June7]

Why does the table show only 691 records?

I can't see anything wrong to cause this issue.

If you want to provide db for analysis, follow instructions at bottom of my post.

[Ted C]

It really only has 691 rows; silly me was looking at the number in the ClassEventID column, which goes up to 770 at present. Some rows containing test data were deleted a long time ago.

[Ted C]

I'll have to see how much work it will take to make the DB shareable.

[June7]

Activate the intrinsic Access navigation bar on the main form. What is the record when clicking the last record button?