Continous form Calculation

[Murray]

I posted a similar question over on General but I think after reading some
posts it should be here.
I have a continuous form which should calculate a total invoice for each
line. When I use my simple code it makes each total on the form the same. Is
it possible to update only the record set where the field is and not the
whole form. The code I am using is :

gsti = 1.1
If GST = True Then (GST is a check box if ticked add amount)
i = Me.Quantity * Me.amount * gsti
Else
i = Quantity * amount
End If
Me.TotalInvoice = i

Thanks

 

[Duane Hookom]

Have you tried using an expression
=IIf([GST]=True, [Quantity] * [Amount] * 1.1, [Quantity] * [amount])

 

[Murray]

Exactly what I was looking for, Thanks

Have you tried using an expression
=IIf([GST]=True, [Quantity] * [Amount] * 1.1, [Quantity] * [amount])
--
Duane Hookom
MS Access MVP

I posted a similar question over on General but I think after reading some
posts it should be here.
I have a continuous form which should calculate a total invoice for each
line. When I use my simple code it makes each total on the form the same.
Is
it possible to update only the record set where the field is and not the
whole form. The code I am using is :

gsti = 1.1
If GST = True Then (GST is a check box if ticked add amount)
i = Me.Quantity * Me.amount * gsti
Else
i = Quantity * amount
End If
Me.TotalInvoice = i

Thanks