Open form with last record

[jarhead58]

Excel 2016

Hello all!!

When first opening the workbook, I have my form show! I want to have it populate with the last/newest record! Am I correct in assuming I would need to do something like this??

Private Sub Form_Load()
        If Not Me.NewRecord Then
            RunCommand acCmdRecordsGotoLast
        End If
End Sub

I tried this with no luck!

 

[Norie]

Is this an Access or Excel question?

 

[jarhead58]

Excel

 

[Norie]

Excel doesn't have anything like RunCommand, it doesn't have 'records' and acCmdRecordsGoToLast is an Access VBA constant, so I'm a little confused.

 

[jarhead58]

Thats why I wa asking for help! Got that from a friend who, I guess, thought it could be used in excel! Any help is greatly appreciated!

 

[Norie]

What do you actually have if not an Access database?

Do you have data in Excel that you are viewing/editing etc via a userform?

 

[jarhead58]

Yes, it's a data entry form to input information! There are about 2000 records. I just want the form to open with the newest record data in the proper text boxes for editing, deleting, etc. when it pops up.