February 17th, 2013, 11:55 PM
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
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
February 18th, 2013, 05:43 AM
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
By qq2 in forum ASP Development
Last Post: December 16th, 2007, 07:20 PM
By ciggwin in forum Microsoft Access Help
Last Post: March 21st, 2007, 11:24 PM
By Ghena in forum ASP Development
Last Post: April 20th, 2005, 12:39 PM
By mnghhl in forum ASP Development
Last Post: March 7th, 2005, 12:54 AM
By bradlam in forum Microsoft Access Help
Last Post: March 3rd, 2005, 10:47 AM