"Docmd.Gotorecord" no longer functions

[HFloyd]

Hello All,

I am using Access 2000 SP-3.

I have a form (recordsource: tblProjects), which has a subform (recordsource: tblTimesheets) linked on a ProjectID (autonumber). The subform displays as a continuous form. I had created a button in the header of the subform that would go to the last record (aka at the bottom of the subform) to quickly facilitate a new entry. For quite some time the button worked perfectly. Now it doesn't work anymore. Clicking the button does nothing, no error message is displayed. I have tried to delete and re-create the button, but it still doesn't work.

Button code is as follows:

Private Sub cmdGoToLast_Click()
On Error GoTo Err_cmdGoToLast_Click

    DoCmd.GoToRecord , , acLast
    
Exit_cmdGoToLast_Click:
    Exit Sub

Err_cmdGoToLast_Click:
    MsgBox Err.Description
    Resume Exit_cmdGoToLast_Click
    
End Sub

I have tried "Compact and Repair", but it doesn't fix the problem.

If anyone has experienced this phenomenon of code suddenly not working and knows how to fix it, I'd appreciate it.

Thanks,

Heather


Floyd Innovations

http://www.floydinnovations.com

 

[Rolliee]

HF,

How do you know it is not doing what you wish. You have just moved the pointer to the recordset. To know if it did what you asked, you have now to look at the record --- or move the pointer to the recordset on the form. You really have not told us enuf to answer the question.

rollie@bwsys.net

 

[HFloyd]

Rolliee,

In the subform, there are enough records that they scroll beyond the bottom of the form. Previously, clicking the button would jump the focus to the last record at the bottom of the list and display the empty (new) record undreneath it. This no longer happens.

For instance: View when opening the form

Previously, clicking the button resulted in this:

Now clicking the button does not change the view:

I hope this clarifies what I am attempting to do.

Thanks,

Heather

Floyd Innovations

http://www.floydinnovations.com