Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    90

    Unanswered: how to calculate?

    Hello all,

    I have one sub form which has the list of quantity. outside sub(also in the same form) form I have one text box which will show us the sum of thats quantity. I dont know how to do this calculation. the list of quantity is appear after the number related it has been key in. So any ideas will be appreciated...please help...coz this is urgent case..
    Last edited by oasislah; 11-05-04 at 05:18.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Set as the ControlSource of your textbox a DSum call ... Ex:

    TotCostBookTxt.ControlSource = "=DSum('[Cost Book]','" & ItemsTbl & "')"


    Then you can just invoke the ReQuery method ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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