Copy Text To Table

[Alexandra]

I have designed a Business Invoice Form. The fields in
the form are generated from a Query based from a Table.
The fields [PartsAmount] contain an expression which
returns a value [Part]*[PartPrice].

I need to create a macro to copy the currency amount in the
[PartsAmount] field to a Table which contains the same
entry "PartsAmount". Since the form field contains an
expression, it does not update it to the table.

Is this possible?

 

[Jim Allensworth]

I have designed a Business Invoice Form. The fields in
the form are generated from a Query based from a Table.
The fields [PartsAmount] contain an expression which
returns a value [Part]*[PartPrice].

I need to create a macro to copy the currency amount in the
[PartsAmount] field to a Table which contains the same
entry "PartsAmount". Since the form field contains an
expression, it does not update it to the table.

Is this possible?

It's possible, but I doubt it is necessary.

If you are saving the values Part and PartPrice then PartsAmount can
always be calculated as needed. The reason being that if somehow Part
or PartPrice is in the future changed then PartsAmount is no longer
valid. And it is taking up unnecessary space.

- Jim