calculating using forms...can it be changed?

[Durien512]

If in a form i have a box that calculates something i cant change that..is there a way around it?

for example on a sales invoice consider the following fields..

sales total

sales tax

grand total

grand total=sales total + sales tax...

but what if i want to change it?? not the formula.. but just to overright it?

 

[gromit]

Hi -

If you have entered a formula for a text box, then you can't change / override the value.

It is possible to set some default values, but this is generally for things that are constant, rather than formulas. (E.g. put "NY" as the default value for State in the customer's address)

It is possible to use Visual Basic to set some values for a default field. However, it requires some familiarity with event properties and detecting changes to a record.

In general, I would think that the Grand Total should remain a calculated field (I wouldn't want to get an invoice with a list of prices and then find out that the total didn't match).

If you just want to change some specific values (like whether or not to include tax) then a conditional formula might be best.

- gromit