#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    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
  3. Contributing User
    ASP Adventurer (500 - 999 posts)

    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

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

IMN logo majestic logo threadwatch logo seochat tools logo