table field default value

[aonefun]

Can the use of an expression populate a field's default value in the following manner:

In the default value area of a table's design view, I placed the following expression: =[GrandTotal]*.06

What I'm trying to accomplish is that the this GSTtax field's default value should equal the value listed in the GrandTotal field multiplied by the number .06

Have received error message of GrandTotal field not existing etc,

Is my method incorrect or are the errors caused by a null value of the GrandTotal field?

 

[PHV]

You can't reference any field in a field's default value expression.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[aonefun]

what would be the proper way to accomplish this task?

 

[PHV]

Use a form for data entry and prefill the GSTtax control in the AfterUpdate event procedure of the GrandTotal control.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886