data from previous record

  • Thread starter Thread starter Squibbly
  • Start date Start date
S

Squibbly

how do i grab info from a previous record field or control and put it into
another field/control
 
You can use the form's RecordsetClone to navigate to any record in the
form's recordset. For example:

With Me.RecordsetClone
If Me.NewRecord then
.MoveLast
Else
.BookMark = Me.Bookmark
.MovePrevious
If .BOF then .MoveFirst
End If
' your RecordsetClone is now on:
' the last record if you are on a new record
' the first record if you are on the first record
' otherwise, the previous record
Me![SomeField] = ![SomeField]
End With
 
Back
Top