[Solved] Copy value from preceding row in grid subform

[calvin123]

Dear all,

I am on Windows 11 with the most recent version of OpenOffice.

In my Base database I do have a customer form which also has a grid/table subform listing items these customers bought.
Now when I create a new item I want to be able to copy the value of the preceding row (and of course column) into the current cell.

So if I have this setup (sorry for the Ascii-Art but the BCode tables don't work):

Customer ABC

Items
ID   | Name   | Description  | Price
1    | Tomato | Red and big  | 2,99
2    | Apple  | ...          | ...

Now when I am in the "Description column of the "Apple" I want to press "F2" and the macro should copy the value of the description of the preceding item "Red and Big" from the "tomato" into the description column of the current item.
And if the cursor would be in the "Price" column, it would copy the "2,99" from the preceding line.
Can you help me?

[Villeroy]

No macro needed.

[UnklDonald418]

Or if you want to try a macro
Base Copy Field or Clone Record - Example

[calvin123]

Thank you both! I will test this later and will give a feedback.

[calvin123]

Hi, it works now.
I looked at both solutions and in the end I went with the macro.

Thank you again and have a nice weekend!
cal