Cannot get desired data on a form

[gregoryf]

I have a table called tblObligMstr. I have a form called frmAmendRecord that is based (bound) on tblObligMstr - three of the fields are ID, IntControlNr, and Amend.

There is also a subform named tblObligMstrSubform. The Link Master and Link Child for the subform fields is IntControlNr. So the subform shows all of the records that have a specific IntControlNr. The form shows the data associated with the first record with a specific IntControlNr

Here is the problem -

The purpose of the form is to show the data for the last record (not the first) in the subform list of records. Certain data on the form can be edited, and then the edited form needs to be saved as a new record in tblObligMstr.

I am almost a novice with Access, but I am totally stumped. Any help will be tremendously appreciated.

I was not sure of what to include with this question as supporting information, so I will supply anything requested.

 

[AlexHedley]

Copy last Record

http://www.599cd.com/tips/access/130921-copy-last-record/?key=AkexForum

 

[gregoryf]

Alex,

Thanks for the reply.

I think the code that is posted works on the last record entered.

I want to get a form with the data from the last record displayed in the subform

I have attached my database. Open form "frmAmendRecord"

 

[AlexHedley]

You could either create a Query that orders the records the way you wish and base the Form on that.

Or add some code:
Private Sub Form_Load()
DoCmd.RunCommand acCmdRecordsGoToLast
End Sub