Calculations In A Form

S

Stefan

I am an admitted novice and need some help in getting my form to do what I
want in relation to the table.

I have a field labeled "5% Option" What I want this field to do is
calculate 5% of another field labeled "Total Cost". I have done this in the
control source of the former but it does not update when I enter the "Total
Cost" figure. I have to proceed to the next record and go back before i can
see the update.

Furthermore what I really want to do with the "5% Option" is this:

"If [Total Cost] is greater than $350.00, then multiply that figure *.05 If
Not Don't Calculate This Field and leave at 0" And I would like it to update
as the person enters a figure in the "Total Cost" Can anyone help me with an
expression for this and where to put said expression? These self-help books
are killing me with vagueness.

I really appreciate someones help.
 
S

scubadiver

Put this in the "after update" event of your [total cost] field

if [total cost] > 350 then 5%option = [total cost]*1.05
else if [total cost]<= 350 then 5%option = 0
end if

I think that might work though I am not too confident with my "End If's"
 
Top