Storing a calculation

[Ruegen]

Sorry, didn't realize it was a percent, try:

PriceTotal = CostPriceExGST + IIf(Me!GSTRegistered = True, CostPriceExGST * GSTPercent, 0)

Wow yes! Thank you so much - works perfectly. Question before I close this - Why use "Me!"? Also why when you give 0 it doesn't bring the CostPriceExGST to 0 as a result if false? Does the 0 just represent adding a null 0? (I think I've answered the second question)...

[June7]

I should have used the Me qualifier on all the control/field references.

PriceTotal = CostPriceExGST + IIf(Me!GSTRegistered = True, Me.CostPriceExGST * Me.GSTPercent, 0)

Me is shorthand alias for name of form the code is behind. The dot will invoke intellisense popup tips.

Adds 0 if GSTRegistered is not True.

[Ruegen]

I should have used the Me qualifier on all the control/field references.

PriceTotal = CostPriceExGST + IIf(Me!GSTRegistered = True, Me.CostPriceExGST * Me.GSTPercent, 0)

Me is shorthand alias for name of form the code is behind. The dot will invoke intellisense popup tips.

Adds 0 if GSTRegistered is not True.

Is it important to have "Me!" ....?

me. I assume is current table and Me! is a different table

[June7]

Both qualifiers are referencing the form the code is behind. I use ! (bang) when referencing a field in the form's RecordSource but not bound to a data control. Use . (dot) to invoke intellisense.

I always give data controls names different from the fields they are bound to, like tbxCostPriceExGST.

[Ruegen]

Ok, Many thanks!