I have a form with 6 text boxes, NumRegular, CostReg, NumSenior,
CostSr, NumChild, CostChld.
I want the Cost* text boxes to update with the result of multiplying
the value entered in their respective Num* box by the cost of a ticket.
I created After Update events for the Num* text boxes similar to the
following:
Private Sub NumRegular_AfterUpdate()
CostReg = NumRegular * 12 'calculate amount for regular tix
End Sub
This works for the Cost* boxes where I enter values in the Num* boxes.
Now I want to create a TotalTix box which gets updated with sum of the
Num* boxes. I added the following event to ALL the *_AfterUpdate Subs:
TotalTix = NumRegular + NumSenior + NumChild 'Total num tix this order
This works great if I enter values in all the Num* boxes but doesn't
work at all if I skip one (not all ticket orders have Seniors, for
example). I want to do the same for a TotalCost box. I don't want to
have to enter a zero when a ticket type hasn't been ordered.
How do I get these Total boxes to update whenever info is entered in
any of the boxes.
Thanks,
Mark Espinosa
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
