data from previous record

S

Squibbly

how do i grab info from a previous record field or control and put it into
another field/control
 
G

Graham Mandeno

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

value in new record based on previous value 2
Need combo box to refresh when moving to new record 2017 1
VBA - retrieve data on last create named range from previous inserted named range 0
AutoFill Form Field 7
Copying from previous record entry 3
Previous Record 1
Repeating selected fields into the next record 2
Lock Previous Record Help! 1

Top