Copy Text To Table

  • Thread starter Thread starter Alexandra
  • Start date Start date
A

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?
 
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?
Click to expand...
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
 
Back
Top