Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    64

    Unanswered: How to calculate OrderTotal in Form?

    I want to calculate “OrderTotal” by multiplying “Price” by “Quantity” minus “DiscountPercentage”

    OrderTotal = (Price*Quantity)-DiscountPercentage

    -- Price is already populated in the form and is a text box.
    -- Quantity will be filled out by salesrep. (Should it be text box or unbound?)
    -- DiscountPercentage will be filled out by salesrep as well and should be from 1 to 20. (Should it be a text box or unbound?)

    How do I do this?

    Thanks for your generosity in sharing the knowledge.

  2. #2
    Join Date
    Jan 2004
    Posts
    64

    Thumbs down Replying to my own post!

    Didnt' get any response at all. However, I made some progress on my own:-)

    I almost works. Maybe this time somebody would post an answer.

    Private Sub Quantity_AfterUpdate()
    OrderTotal.Value = Nz(Me.Price.Column(1, Me.Price.ListIndex), 0) * Quantity.Value
    End Sub

    When I use this the same OrderTotal appears on all the records.
    How can I correct it?

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •