[Solved] Help! Field calculation with Macro Basic code

[master-plan]

Hi all,

I've started using LibreOffice a couple of months back and have some intermediate knowledge of MS Access.

I've been scratching my head for a few hours already and in desperation I'm submitting this post. (I've searched around but can't find an answer... though I'm sure someone must have posted a similar question before).

So here it goes:

How can a field be recalculated in a *form* after a record change?

For example, if we have

FIELD_01 = 10
FIELD_02 = 2 (update record)

then (after record update) FIELD_03 = FIELD_01 * FIELD_02

In access this sort of thing (maybe in an incorrectly structured way) was easy to do. But still struggling with LibreOffice...

*Note:* I'm aware that calculations should be done on a Table/ Query level, but what if it's something very complex and it needs to be done via a Macro in Basic and within the Form?

Any help much appreciated. Thanks in advance.

[master-plan]

Solved. See my other post:

"Macro- Form, copy one record field to another table [Solved]"