Can DLookup refer to the previous record? (1 Viewer)

[DocNice]

Hi, I have a repeating form, and I wondered if there was a way to put in a field that would look up something based on info in the previous record.

Basically, I want to display info for the user's reference saying that this record refers to where the last record ended +1.

I know it's a long shot, but it's worth a try before I scrap my entire form.

 

[llkhoutx]

The "previous record" is best found using bookmarks.

dim rs as dao.recordset
set rs = me.recordsetclose
rs.moveprevious
me.bookmark=rs.bookmark

The foregoing, of course, assumes that a previous record exists.