Auto-fill data with data one record above when creating a new record

Question

Hi

Is it possible (and if it is possible: how?) to auto-fill (in the example below) field E with the data of field D when I create a new record?

Row 1

Row 2

Row 3

Row 4

A

B

C

D = A+B-C

E = D from the row above

F

G

H = E+F-G

Answer 1

Hi

Is it possible (and if it is possible: how?) to auto-fill (in the example below) field E with the data of field D when I create a new record?

Hi Domenic,

I remember that I used a long time ago some short-key combination with Shift or Alt, but I forgot how it worked, and I can't find it anymore.

In general I work in this way:

- make a clone of the form's Recordset: Set clone_set = Me.RecordsetClone

- Synchronize the sets: clone_set.Bookmark = Me.Recordset.Bookmark

- step back one record: clone_set.MovePrevious

- get the value of the field and assign: Me.ActiveControl = clone_set(Fieldname)

- close the set: clone_set.Close

Most important is you get the idea.

You can wrap this in a Sub that is triggered by a clicking a command button. It is also possible to couple this to a short-key, but that is more complicated.

Imb.