value of the last record

[Dan]

Is it possible to set a text box to equal the last,
first, previous, #5, etc records.

What I am trying to do is have a text box on my form
display the last record, a previous record of the
selected record that are located on the linked subform.

 

[Dan]

I meant that I am trying to get a text box to equal the
value of the field [amount due] of the previous record