Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: how to auto calculate in forms help

Results 1 to 2 of 2
Share This Thread →
  1. #1
    jeffrey159 is offline Registered User
    Join Date
    Jul 2012
    Posts
    18
    Rep Power
    0

    Cool how to auto calculate in forms help

    i have a tblTicket with a set of data about the amount of sold tickets with 2 seat options
    2 data field
    Combobox Stand, Cabin
    Sold_Tickets

    in Tickets Form,
    when i select ticket type Stand.
    how do i make it auto calculate in the form to show the amount of sold tickets for 'Stand'.
    and if i add new records it should calculate and add in the total amount in it.
    any example for this kind of code??



    sorry for my english

  2. #2
    meratigoerr's Avatar
    meratigoerr is offline Contributing User
    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    58
    I'm going to assume you want the total number of stand tickets sold to date for a particular event or for a particular date. One method is to create an aggregate query to sum up all of the number of tickets sold. Add a subform to your main form using the query as the record source. (You can format it so that it doesn't even appear to be a subform.) Then in the after update event on your combo box or sold_tickets box just use the code: me.subformname.requery

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

Similar Threads

  1. Auto calculate total
    By qq2 in forum ASP Development
    Replies: 2
    Last Post: December 16th, 2007, 07:20 PM
  2. Need Help with Auto-Fill in forms
    By ciggwin in forum Microsoft Access Help
    Replies: 2
    Last Post: March 21st, 2007, 11:24 PM
  3. listin auto calculate
    By Ghena in forum ASP Development
    Replies: 8
    Last Post: April 20th, 2005, 12:39 PM
  4. How to auto calculate utilization rate
    By mnghhl in forum ASP Development
    Replies: 4
    Last Post: March 7th, 2005, 12:54 AM
  5. Auto tabs in forms
    By bradlam in forum Microsoft Access Help
    Replies: 2
    Last Post: March 3rd, 2005, 10:47 AM

ASP Free Advertisers and Affiliates