Caculate Sums on a Form

[Fortborg]

Hi,

I know this could probably be done if I take the time to play with it, but I just don't have the time for that. Here's my situation:

I have created a Form for customer information, and a sub-form to enter their different events.

Events are: Buying Product A:

Number of Product B:
Number of Product C:
Number of Product D:

I want to be able to type in the number they've bought and have it automaticly caculate the total value.

If they order 10 of Product B, Product B cost $5.00 each, can it tell me they've bought $50 worth of Product B right there on the Form? Something like that, any help would be welcome.

-Fort N'zur

 

[jimmythegeek]

No problem, use the AfterUpdate, or OnLostFocus event of the Qty field to specify the code.

Let's say you have the following fields:

ProdB Qty BExt

On the AfterUpdate Event of the Qty Field put the following code:

==========
Private Sub Qty_AfterUpdate()
Me.BExt = Me.ProdB * Me.Qty
End Sub
==========

After you update the qty field, the extended price will populate automatically.
Jim Lunde
compugeeks@hotmail.com
Custom Application Development